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

Have a look he

http://exceltips.vitalnews.com/Pages...me_Values.html

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Oliver" wrote in message
...
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