Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day,
I have a TIME here but not formatted into time.
Sample:
15.13 late means 15 hours 13 minute late. how can i convert it into a TIME.?
Thanks.
interval(interval#('15.13','hh.mm'))
You may use
Interval(Interval#('15.13','hh.mm'),'hh:mm')
to get the time in HH:MM format.
If you need the internal representation of time for further calculation, you may use
Num(Interval#('15.13','hh.mm'))