AnsweredAssumed Answered

Convert Time to Number

Question asked by ChristopherColes on Aug 29, 2018
Latest reply on Aug 29, 2018 by okramis

I have an AfterCare db where I capture timestamps for checking in and checking out students.  I have a field that is a calculation that subtracts the TimeIn - TimeOut and gives me answers in H:M:S as it should.


I would like to convert this to a number.




TimeIn = 3:00 PM

TimeOut = 4:30 PM

Calculation = 0:1:30


Would like to convert 0:1:30 to a number such as 1.5 (hours).


This possible?


Many thanks in advance.