0
Time formatting
I'm trying to use the Format function on time values, but the results are adding 7 hours. For example:
format(time(4.13,0), "hh:mm:ss") should result in 04:07:48, instead I get 11:07:48. Am I doing something wrong?
4 replies
-
"format" always needs datetime as argument. try this:
---
format(datetime(date(2018, 4, 24), time(4.13, 0)), "hh:mm:ss")
---
Regards
Leo
-
Thank you. Not what I was hoping for, but I can always put a "dummy" date.
-
exactly :-)
-
you can also use the today():
---
format(datetime(today(), time(4.13, 0)), "hh:mm:ss")
---
Content aside
- 6 yrs agoLast active
- 4Replies
- 2855Views