Elapsed time Formulas

[crystalthornburg]

I need to know how to put a formula in Excel 2003 that will calculate elapsed time from one DATE to another in HOUR format?

Example: from 9/12/13 08:30 to 9/15/13 14:30 is how many hours?

I need the formula PLEASE

I already know how to calculate time within a 24hr period but not with multiple days.

[Jakobshavn]

With the latest value in B2, use:

=24*(B1-A1)

and format the cell with the formula to "General"

[JieJenn]

something like this?

[crystalthornburg]

Thank you very much. I got another question out there posted maybe you guys have the answer....

[Maxfli58]

This looks great but MY issue is a need to enter and add elapsed time values as enter from a stopwatch. When I enter 18 mins 44 secs (18:44) when the cell is formated with CUSTOM, mm:ss, it shows as 12:18:44PM. I need to enter time values for specific events and then add for the total time value.

[alansidman]

@ Maxfli58

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.