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.

 

Example

 

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.

Outcomes