Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How do I get the timestamp from values like 0....420, 421, 422, 423....1430 where the values in the interval is minutes and the starttime is from 00:00 (12:00 a.m)?
Example 420 = 07:00 (7:00 a.m) and 1400 = 23:33 (11:33 p.m)
Thanks for suggestions
SImply this:
=Time(Value / 1440)
(because there are 24*60 (1440) minutes per day)
try like this:
=interval(interval#(420, 'm'), 'hh:mm')
SImply this:
=Time(Value / 1440)
(because there are 24*60 (1440) minutes per day)
=Time(YourFieldName/60/24)