Times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How enter time DURATIONS mm:ss (not clock times), then sum? 1
Adding Time Function 4
Time Sum in Excel 1
If time falls within time.. 5
Adding Time 7
Converting Seconds to mm:ss format 3
Calculating a Target time from an Actual Time... 2
Summing minutes and seconds 2

Back
Top