Times & Seconds Problem

[GlenS18]

I need to convert a time in a numerical value. The time is in th
format hh:mm:ss.

The best way is to give an example of converting 00:01:00 into bein
displayed as 60 (seconds)

Thanks

Gle

 

[Frank Kabel]

Hi
if your time value is in cell A1 use the formula
=A1*24*60*60
and format this target cell as 'General'

 

[GlenS18]

Thanks for that. Worked a treat.

Would be grateful if you could explain just how it works? I take it it
has something to do with hours, minutes, seconds etc like 24 hours in a
day, 60 minutes in an hour, 60 seconds in a minute?

 

[Chip Pearson]

Glen,

In Excel, times are stored simply as a fraction of a 24 hour day
(e.g., 6:00:00 = 0.25, 12:00:00 = 0.5, 18:00:00 = 0.75, etc). To
convert an Excel time value to seconds, for example, you must
multiply the time value by the number of seconds in a day
(24*60*60=86400). Similarly, to get the number of hours in a
time value, you multiply by the number of hours in a day (24).

For lots more about dates and times in Excel, see
www.cpearson.com/excel/datetime.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[wennerberg]

If time is in cell A2, format another cell as NUMBER and use thi
formula in that NUMBER cell:
=(86400)*A2

86400 is the number of seconds in a day. It helps to remember tha
Excel stores dates and times as a regular old number with the decima
portion being a fraction of one day. (To see this number, take one o
your HH:MM:SS cells and format it as number.