Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,616
- Office Version
- 365
- 2016
- Platform
- Windows
ts1 = 43123.66667 (January 23, 2018 4:00PM)
ts2 = 43123.75000 (Januray 23, 2018 6:00PM)
How would I calculate the number of minutes between these two times?
I have :
This gives me close to what I need. The answer should simply be 2.0, but I'm getting 1.99992.
Solution was more simple than I thought ....
ts2 = 43123.75000 (Januray 23, 2018 6:00PM)
How would I calculate the number of minutes between these two times?
I have :
Code:
dhrs = (t2-t1)*24
Solution was more simple than I thought ....
Code:
dhrs = format((t2-t1)*24,"0.00")
Last edited: