Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Discussion (Misc queries) | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) |