formula to calulate length of time

G

Guest

I need to create a formula that displays the length of stay between to dates
in a cell. For example the length of time between date 1 = 2006/01/06 12:30
pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in hours.
 
N

Niek Otten

=A2-A1
Format>Cells, Number tab, Custom. In the Type box, enter [h]
in your case the result is 166 hours
 

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

Converting text format of time/date into Excel time/date for subtr 5
Adding recognised Zeros 5
separating date and time 5
Subtracting time...again 2
how do I write an IF/other statement to cut off time data? 15
Adding hours/minutes to Date/Times 1
Picking out a Period, in relation to certain cells 6
time_report_date-wise_employee-wise 6

Top