Calculating the difference between hours

O

Oliver

I need to be able to calculate the difference between the two figures, which
are both quantities of hours and minutes. For example 10,000hrs and 28
minutes minus 28 hours and 23 minutes. For any figures less than 10,000 the
formating [h] mm works correctly but when I try and do the same with any
figure of 10,000 hrs or higher the equation returns #VALUE. How should I
change the equation ? Thanks Oliver
 

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

Subtracting time...again 2
How to calculate difference between two date & time along with working hours and days 2
Calculating the difference, in hours, between two date/time in two different time zon 2
Date/time difference 6
Calculate the difference between two times and show dd:hh:mm:ss 7
Calculate between start and end times 2
Calculating Difference Between Two Times in General Format 5
difference between two time 3

Top