HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES

G

Guest

Start date and time is 9/12/05 06:35, finish date and time is 9/13/05 13:45.
TOTAL hours are 31 hrs 10 min. I tried different forulas and would only get 7
hrs 10 mins. excel kept leaving off the 24 hours. Is there someway I can get
excel to add the total hours without leaving off the 24.
 

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 elapsed time excluding specific timeframe 10
how do i find # hrs & mins. between 2 different dates and times 3
Need difference between two dates/times in hours 10
TimeSheet Using 100 Minutes & Rounding to .25 2
Adding Days and Hours 8
Peak call times/hours 2
how to calulate time in hours cbetween two different dates? 3
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2

Top