Hi,
How do I convert whole number to Time?
E.g. I have Time1: 01:20:00 & Time2: 01:25:00
The result should be: 00:05:00
I used this formula to get Total minutes= 60 * (substring(Later Time, 12, 2) - substring(Earlier Time, 12, 2)) + (substring(Later Time, 15, 2) - substring(Earlier Time, 15, 2)) + (substring(Later Time, 18, 2) - substring(Earlier Time, 18, 2)) / 60 & the result is Total Minutes in wholenumber
But, I would like to know how to parse from wholenumber to Time or if I get help to subtract directly & displaying in time format?
Thanks,