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).
Many thanks in advance.