Custom format your cell(s):
[h]:mm
The brackets prevent the hours from rolling over into days.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"John Knoke" wrote in message
...
I calculating "uptimes" of machines.
If I have a 100 machines that can work 24 hours it means I have
2400 machine hours of productivity.
I am not able to display 2400:00
tks for any help
|