| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
The thread aged off for me, but if I enter:
00:04:11 in A1, I can use this in B1: =A1*60*60*24 (formatted as general) and get 251 back. Saray wrote: Hi all, How can I convert the minutes (which is presented as 4:11) to seconds? I have tried all the solutions posted on this thread but none of them worked! Help!! Thank you! -- Saray ------------------------------------------------------------------------ Saray's Profile: http://www.excelforum.com/member.php...o&userid=27087 View this thread: http://www.excelforum.com/showthread...hreadid=276410 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| how do I add minutes and seconds together in excel | Excel Worksheet Functions | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
