Times

[Gregory Jones]

I want to enter minutes and seconds in a cell like 1:30 (mm:ss) I can't use
the format "Time" because it returns something like 1:30 am. I really want
to have the cells value be read as 90 seconds. This is more of a duration
concept than time concept. Any ideas?

Thanks in advance for your help

 

[Frank Kabel]

Hi
format the cell with the custom format
[ss]
or
[mm]:ss

 

[Jason Morin]

Go ahead and enter the times as seconds (like 90, 120, 45).
Because XL works with time in fractional days, you can
convert the times to seconds with:

=A1/(60*60*24)

Format the formula cells as [mm]:ss.

[mm]:ss

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

If you type 1:30, that is interpreted as 1 hour and 30 minutes. To have Excel
recognize it as 1 minute and 30 seconds, you must type 0:1:30.