| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Minutes to seconds
Hi, I'm facing a little problem and I have no idea how to solve this, so I hope some of you guys can help me out on this. I'd like to see a time of for instance 6:08.74 (6 minutes, 8 seconds and 74 hundreds) to be calculated as a value of 368.74 seconds. So let's say C10 says 6:08.74 then I'd like to have a formula in C11 which tells me that it's the same as 368.74 seconds. Hope you guys can help me out, thanks is advance Partysquad. -- Partysquad ------------------------------------------------------------------------ Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970 View this thread: http://www.excelforum.com/showthread...hreadid=487030 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Minutes to seconds
=C10*24*60*60
-- HTH RP (remove nothere from the email address if mailing direct) "Partysquad" wrote in message ... Hi, I'm facing a little problem and I have no idea how to solve this, so I hope some of you guys can help me out on this. I'd like to see a time of for instance 6:08.74 (6 minutes, 8 seconds and 74 hundreds) to be calculated as a value of 368.74 seconds. So let's say C10 says 6:08.74 then I'd like to have a formula in C11 which tells me that it's the same as 368.74 seconds. Hope you guys can help me out, thanks is advance Partysquad. -- Partysquad ------------------------------------------------------------------------ Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970 View this thread: http://www.excelforum.com/showthread...hreadid=487030 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Adding minutes & seconds | Excel Discussion (Misc queries) | |||
| Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Linear Mode
