DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL

G

Giulia

Help I am been driven mad!
Does anyone know how to find the difference between two time stamps giving
the result as a time decimal.
I.E.
16:45 - 12:00 = 4.75 hrs
 
D

David Biddulph

Giulia said:
Help I am been driven mad!
Does anyone know how to find the difference between two time stamps giving
the result as a time decimal.
I.E.
16:45 - 12:00 = 4.75 hrs
Click to expand...

=(A1-A2)*24 and format as number rather than time
 
Top