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

How can I count hours & minutes??!!
 

Format the cell as [h]:mm:ss (note the square brackets)

--
Ian
--
"jamespickett23"
<jamespickett23.1x3eea_1129629905.9685@excelforu m-nospam.com wrote in
message news:jamespickett23.1x3eea_1129629905.9685@excelfo rum-nospam.com...

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

How can I count hours & minutes??!!
 

60 hours, are you sure you don't mean 24?

If you format the cell as [h]:mm:ss you can see more than 24 as the hour
count.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jamespickett23"
<jamespickett23.1x3eea_1129629905.9685@excelforu m-nospam.com wrote in
message news:jamespickett23.1x3eea_1129629905.9685@excelfo rum-nospam.com...

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