Calculating elapsed time between two dates and times

Hello!

I'm not sure if this is possible because my search results only yielded how to calculate elapsed time between two times or between two dates.

I'm looking for a way to calculate elapsed time between two dates AND times e.g. March 15, 2021 10:33pm to March 16, 2021 7:0am. Is this possible? My spreadsheet has the first set of dates and times in Columns A and B, respectively, and the second set of dates and times in Columns C and D. If this IS possible, I would also like to be able to customize the results to display elapsed days and hours, or total hours only.

A small screenshot showing the columns in my spreadsheet:
Screen Shot 2021-04-08 at 08.30.40.png

Thanks!

Chris

Yes! You simply subtract. But you said you have dates in column A and times in column B. What are the two dates/times you want the elapsed time for? Your formula will look something like

=A2+B2-A1-B1

assuming you want to take the date/time in row 2 and get the time elapsed from the date/time in row 1.

Use the custom format

d h

and the result will be elapsed days and hours.

[h]

will give total hours

Administrative Note:

Please add your Office version to your forum profile.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

I'm sharing a portion of the worksheet here (per JohnTopley's post), with the hopes that we can figure this thing out.

The "Duration" column's formulas doesn't seem to be properly calculating anything over 24 hours (see rows 4 and 5).

Thanks to everyone for your help and contributions with this

Chris

Did you set the custom cell formatting to [hh]:mm? If not, you won’t get hours over 24.

It is calculating it correctly but your format is not quite what I suggested. As Ali notes it must be

[h]:mm

You need the brackets around the hours for over 24.

That's correct - you need to open the file in the desktop app to create and update custom formats, which of course you can do directly from the browser ribbon. When you say 'obtain' the original file, I am not sure quite what you mean, but it's important that you always work on the shared version, not a copy of it.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.