LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to convert 157.25 minutes, into hours, minutes and seconds. Al Excel Discussion (Misc queries) 2 March 11th 09 09:04 AM
Converting hours, minutes, seconds, to hours chouck Excel Worksheet Functions 7 January 29th 08 08:00 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
Converting hours:minutes:seconds to just minutes Dan Vagle Excel Worksheet Functions 3 July 17th 06 11:20 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"