Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LaurieC.
 
Posts: n/a
Default what is the formula to convert time (3:46) to total seconds?

I'm looking for a formula that will convert a time in minutes and seconds to
total seconds. EX 3:46 which is 3 minutes and 46 seconds and is 226 seconds
total.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default what is the formula to convert time (3:46) to total seconds?

Hi!

If your time is in cell A1:

You can apply a Custom format of: [s] and it will display as 226.

Or:

=A1*24*60*60

Format the cell as GENERAL.

Note: if you try A1*86000 you'll get less than 226.

224.953703703704000

Biff

"LaurieC." wrote in message
...
I'm looking for a formula that will convert a time in minutes and seconds
to
total seconds. EX 3:46 which is 3 minutes and 46 seconds and is 226
seconds
total.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
Formula to deduct unpaid breaks in time sheet Rick Excel Discussion (Misc queries) 3 August 26th 05 11:53 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM
Accumulate weekly time to total time in Excel. delve Excel Discussion (Misc queries) 0 May 4th 05 08:14 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"