DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL

G

Guest

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

Difference between 2 time stamps 5
How to calcuate the difference between two times in tenths of a mi 1
Round time to nearest 15 minutes in decimal format 4
Subtracting time...again 2
show time difference between start and end times 6
Timesheet calculations 1
Caluculate difference between two times 7
Difference between two Excel Date/Time Stamps 7

Top