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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
separating date and time 5
Subtract times? 2
Round time to nearest 15 minutes in decimal format 4
How to calcuate the difference between two times in tenths of a mi 1
Difference between 2 time stamps 5
Difference between two times in seconds 1
Time Duration Calculation help needed 4

Top