How to Add or Subtract Time in Excel - Calculate Hours and Minutes for Accurate Timekeeping

why i can't find (datedif) equation in my excel, even i changed my excel version ?

What about if you have 24 hrs shifts. How do you add the hours from one day to the next?

Thanks a lot. your explanations are so explicit

Nice

Excellent video...to the point, and encouraging/positive tone throughout. Funny, I ended up watching it all the way even though I figured out I wouldn't get the answer I was searching for. Just fun to watch. Never thoughts I'd say that about an Excel tutorial :). I am unfortunately strugging to find answer I'm searching for. **Shannon, I am unsure if you will see my message here, or if you have the time to help figure out the answer I'm searching for. What I am trying to do is enter a time value in column "C", and based on that particular time value I entered, the neighboring cell in column D, it will say 1 of 6 different possible things. So the cell in column D, it will display a value/text, based on the time I enter in the cell under column C. For example: if I enter a time value between 8:30 AM ~ 9:30 AM in column C (let's say it is cell C2 for this example), then cell D2 will display "Pre Market". If I enter a time value in cell C2 that is between 9:31 AM ~ 12 PM, then cell D2 will display "Morning". If I enter time in C2 between 12:01 PM ~ 3:30 PM, cell D2 will display "Afternoon". If C2 time is between 3:31 PM ~ 4PM, then D2 displays "Final 30 Minutes". If I enter in C2 time value between 4:01 PM ~ 5:59 PM, then D2 displays "Afterhours". C2 value is 6 PM ~ 2 AM, then D2 displays "Asian Session". If C2 value is 2:01 AM ~ 8:29 AM, then D2 displays "London Session". If you have a moment, can you please help me get this formula started. Any advice, any video you can point me to (especially if it is a video you have created, it is easy to watch). Anything at all greatly appreciate. PS: I understand it likely I won't see a reply to this message, but regardless, I am wishing you and family a Happy Thanksgiving.

Hi Shannon. I thank you for explaining the last part. I always had a problem with that.

thanks.

Hi Shannon! I got a problem in subtracting the time, it comes out a negative answer in number (Minutes) especially if the subtrahend is bigger than the minuend.

I’m getting 0 as total hours when I know it’s like 50 😢

Sharon, finally a good tutorial on how to handel time in excel. I need help on a formula to display time when its past midnight. Here is the issue my server tells me the "minutes since event" when I run an event log in the mornings. I downloaded the event log in excel and added the current time. I subtract the "minutes since event" column and format the cell like this =+$D$1-TIME(0,B10,0) Where $D$1 is the time the log was run and B10 is the minutes since the event. All is good until we pass midnight and Excel has to change fro AM to PM, when this happens, my formula returns the # sign. Can you help me? Some of the minutes on the event log are over a 1000, so that's over 12 hours. Thanks, Mike

Thanks

What a great explanation. Thanks!!

I understand that Excel Online has less features, but deducting minutes from time yields just number signs (###).

Great video as always. What would the formula be to calculate the difference between the end time of one day with the start of the next day?

This chanel is needs more viewers. I learned a lot from her tutorial.

Great,