HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES

T

tankerman

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

Excel: counting times and dates during non-traditional hours 0
Calculate elapsed time excluding specific timeframe 10
Calculating the difference, in hours, between two date/time in two different time zon 2
How to calculate difference between two date & time along with working hours and days 2
how do i find # hrs & mins. between 2 different dates and times 3
Countif between Time stamps and have - value 0
Adding Days and Hours 8
problem with time subtraction 7

Top