Format Cells for time

  • Thread starter Thread starter Jas2be
  • Start date Start date
J

Jas2be

I have a list of time values in seconds. I would like the
seconds to be converted into a decimal format.

Example
..30 seconds to be .5
..45 seconds to be .75
..15 seconds to be .25

Is there a format option to accomplish this?

Thank you,
Jason
 
If they are time values and .30 seconds is 30 seconds, then you can use

=A1*24*60

or

A1*1440

format as general

if it is 0.3 as a decimal value

=(A1/864)*1440
 

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

i want to convert decimals into time format 3
Multiple Formula Custom Formatting 4
Time format in Excel 1
Custom Number Formatting 4
formatting cells for time 1
Decimal/Percentage to Whole Number 4
Difference between two times in seconds 1
convert time in decimals to minutes 2

Back
Top