View Single Post
  #1   Report Post  
jamespickett23
 
Posts: n/a
Default How can I count hours & minutes??!!


The problem I got is that the format is in 24 hour clock, so when im
counting hours it defalts back to 00:00:00 after 60 hours of counting
(I don't know why 60).

Im looking for a way to count up to 1000 hours including minutes

e.g. 956:35:00 = 956Hours 35Mins 00Seconds

Any help is most appriciated.

James


--
jamespickett23
------------------------------------------------------------------------
jamespickett23's Profile: http://www.excelforum.com/member.php...o&userid=28179
View this thread: http://www.excelforum.com/showthread...hreadid=477085