Using time calculations in Excel

[tuccokeith]

Hello,

I am trying to enter a program run time into a column in Excel.

What time format can I use that will allow me to just enter the run time without excel trying to convert it to am/pm time.

For example if I enter 00:00:10 (run time of 10 seconds) Excel indicates in the formula window that the time is 12:00:10 am. I tried to use the custom formatting but it is not working.

 

[bluedragon2]

If you do not have to do any calculations on it put a ' in front of it. This will convert it to text. Even if you do wnat to make calculations on it, you can convert the text to individual numbers by incorporating the left,mid,right and value functions.



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

I would almost NEVER suggest entering aTime as a STRING -- sorry, Blue.

Format your Time Cells as Custom [h]:mm:ss

Your Time will be displayed without the AM/PM. HOWEVER, since your value IS a Time Value, Excel stores it as if it were any other Date/Time value.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[tuccokeith]

Hello,

I am trying to use the run time in a the following formula:

SUM(D2*2)+C2

Where Column d2 equal run time
and Column c2 equals start time

How do I make the run time values remain in a hh:mm:ss format?

 

[SkipVought]

You format ALL the cells involved that way. Do if
[tt]
D2: =01:01:30 ' one hour, one minute, 30 seconds
C2: =13:00:00 ' one o'clock
[/tt]
then if the result were in B2:
[tt]
B2: =Sum(D2*2)+C2 ' 15:03:00
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bluedragon2]

Yeah Skip, I had a brain poof on that one...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...