View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Hours and Minutes

A|re you storing the values of time and finding it can only go as far as 24?
If so, format the cell as [h]:mm

--

HTH

RP

"BPHMA" wrote in message
...
I am trying to keep track of the hours and minutes a machine has operated.
This can get up to 20,000 hours. How do I add daily operating hours to

the
begining total?