How do I calculate duration between two dates and times in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculate the difference in hours between two dates and times. For
example the difference in hours between 11:25 on 23/07/2004 and 18:00 on
06/08/2004? The dates and times have already been determined by the start and
end of a particular event. Thanks,
 
Let's say the 23/07/2004 date is in A1 and the 06/08/2004 date is in B1

C1 =(B1-A1)*24 gets time in hours. Ensure that C1 is formatted to say
NUMBER with 2 decimal places.
 
One way:

=ROUND((A2-A1)*24,0)

where A1 has your start date/time and A2 has your end date/time. Since
XL stores times as fractional days, multiplying integral plus fractional
days by 24 gives hours.
 
You must log in or register to reply here.

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

Number of hours between now and selected date 5
Determine if night shift by start & end time 2
Calculating diff between date/ time only between certain hours 5
how can we calculate the numbers of hours between two dates and 4
[NEWBIE] date/time diff 4
Calculating time between mulitple dates 4
Length of time from date/time custom format 2
Calculate times between dates and times in Excel 1

Back
Top