Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells with hours, minutes, and seconds
Hello, I have a column labeled "task time". In my spreadsheet, I have
a requirement to track how long a job's tasks take and come up with a total elapsed time for all the work. So if I have a manufacturing process which takes 61 seconds to set up and it runs for 8 seconds, On row 1, I want to enter 00:01:01. On row two I want to enter 00:00:08. and so on and so on until I get to the end of the rows and total that column. The problem is whenever I enter 00:01:01, 00:00:08, etc., then a date gets appended to my entry!!! I even tired to apply a custom mask, like hh:mm:ss or mm:ss, to the cell's format and the date still gets placed in my cell! How can I prevent this from happening? How can I have a time type and not have a date to go along with it? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Converting hours, minutes, seconds, to hours | Excel Worksheet Functions | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |