This question already has an answer here:

I have two time-formatted cells and I need to calculate the difference (e.g., 2.75) in hours between the two.

10:30 AM   |   1:15 PM



will not do the trick.

marked as duplicate by ale, serenesat, Rubén, jonsca Dec 9 '16 at 0:49

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


I would use the following formula to calculate the difference in hours.




The time difference is calculated in days. If you multiply times 24, you end up with hours. Time difference is 2 hours and 3 quarters of an hour (165 min).


enter image description here


I've prepared an example file for you: Time Tracker formula and included your own solution in C1.

  • @pnuts added example file. Did you find my answer useful? – Jacob Jan Tuinstra Apr 24 '14 at 13:43

To calculate the time difference in hours between

10:30 AM   |   1:15 PM

Use the formula:


and format that cell as Duration

  • 1
    Format => Number => Duration – mshakeel Aug 30 '17 at 7:02

In Google Sheets, I used the formula

=Round((hour(A2-A1)*60 + minute(A2-A1))/60,2)

to give me the difference in decimal hours.


I've created this formula, it might help somebody else.

=iferror(if((minute(E3) - minute(D3))>=0;hour(E3)-hour(D3) + (minute(E3) - minute(D3))/60;hour(E3)-hour(D3) + 1 + (60 - minute(E3) - minute(D3))/60))
  • What's the time difference you expect? – Jacob Jan Tuinstra Apr 24 '14 at 11:22
  • This just gets the time in hours. I'm using it in a time-tracking sheet for billing purposes. – Zlatko Apr 24 '14 at 11:42
  • 2
    Yeah I understand, but what is the time difference between 10:30 AM and 1:15 PM? – Jacob Jan Tuinstra Apr 24 '14 at 11:47

Not the answer you're looking for? Browse other questions tagged or ask your own question.