How to Calculate Time in Google Sheets

In this video, I show how to calculate time in Google Sheets. I show formatting cells as time, calculating time difference, adding time, and subtracting time. At the end of the video, I show how to make a basic timesheet to calculate hours worked.

Read through the full tutorial here:

Timestamps:
00:00 Intro
00:39 Formatting Cells as Time
1:28 Calculating Time Difference
2:29 Adding Time
3:31 Subtracting Time
4:40 Making a Time Sheet in Google Sheets

[kens]

Thank you, just what I was looking for. Your video is the quickest and simplest.

Way simpler than converting times into decimals, separate hour/minutes divided by 60 column, converting the decimals back into hours divided by 24 hours in a day.

[emilyautor]

this is the simplest explanation. loved it.

[libbysworld]

Great time sheet. If you'd like to calculate OT, use this formula: '=if(C2<B2), C2+1, C2)-B2-TIME(8, 0, 0) and replace the "8" in the ending parenthesis with whatever your normal hours are for the day.- Pro TIP!!

[rabidralph]

excellent stuff been looking at lots of videos and yours was the first I came across that said use duration for the lunchbreak that's where I was going wrong thankyou so much

[sbanagas]

Thank you so much. This helped me immensely!!

[freeblxaccounyLOL]

thank you! It was straightforward and exactly what I need for ojt

[AndreaMartinez-qudp]

Thank you! I didn't know there was a Duration format :)

[bdul]

That's actually what I was looking for thx a lot

[RickyPiscoSour]

Great video!
But I'm having problems with times that start at 3pm and end at 12am

[HassanAli-wlid]

Thank you for the video. i keep getting this Value error: The MINUS function, parameter 1 expects numeric values, but «10:15» is a text and cannot be forced to a number.

What do i do?

[TheBizzyBScience]

How would you calculate the final hours worked cells to multiply by hourly rate to $ £ etc?

[MelissaCettina]

Do you have a video showing how to calculate the lunch break where the time might vary each day? Like a clock in/clock out situation for lunch as well subtracted from the total time worked? Thanks!

[s_hi_kooo]

Hi but is there any option to show time with miliseconds? I need to compare times from driver A and driver B (minutes:seconds.miliseconds) I've done my best :/

[jujumomah]

I've tried your way of adding time. However, I have values such as 2pm to 4am. The difference comes out as negative. How do you that in that give time?..