how can we calculate the numbers of hours between two dates and

R

Rama Chandra

i need to calculate the exact number of hours between two different dates and
times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.
 
J

JLatham

Subtract the earlier value from the later one and then use Format --> Custom
format:
[h]:mm:ss
For example with 04/12/10 10:23 AM in A1 and 04/15/10 15:18 in B1 then
=B1-A1
and with the custom formatting applied will display 76:55:00, which is 76
hours and 55 minutes.
 
J

JLatham

If you would rather have the result as a decimal number (76.91667 hours for
the previous example), then
=(B1-A1)*24
and format the cell as either General or one of the Number formats.
 

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

Calculate working hours between two dates 2
How To Calculate the Number of Fridays between two dates. 5
Calculate the difference betwen two columns -two dates 3
Calculating diff between date/ time only between certain hours 5
Calculating the difference between two times 1
Calculate number of hours between dates and times excluding Weekends 1
Difference between dates and times 5
years-months-days-hours 5

Top