calculating date time ranges

P

Patrick

I have a spreadsheet that I wish to calculate the number of hours between two
events. The first event has a date column and a time column (i.e. 11/9/04
0700) the second event also has a date column and a time column. I would like
to calculate the number of hours difference between the two events. Example
first event 11/01/04 0700 and second event 11/05/04 1100.
Thanks for any help
 
A

anilsolipuram

Just do the difference of the dates.

But make sure the resulting cell has the custom format "[hh]:mm"
 
M

Myrna Larson

Assuming earlier date in A1, time in B1, 2nd (later) date in A2, 2nd time in
B2


=A2+B2-(A1+B1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
separating date and time 5
How do I count the number of blank cells 0
countifs Function not giving desired result with date criteria 2
Calculating date/time intervals?? 1
Calculate elapsed time excluding specific timeframe 10
IF ARRAY with multiple conditions. 1
Schedule Events 2

Top