| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Seconds to Minutes
If you like the law or sausage, you should never watch them being made.
Same with my formulas! "Rick Rothstein (MVP - VB)" wrote: LOL Rick "Dave Peterson" wrote in message ... Well, I had to fix it a few times to get the quotes right <vbg. "Rick Rothstein (MVP - VB)" wrote: Maybe slightly less ugly: =TEXT(A1/86400,"[m] ""minutes and ""s"" seconds""") Thanks for noting that. I don't know why, but I keep forgetting that you can force the quote marks around pieces of text in order to escape the characters contained within them... some kind of mental block, I guess. Rick -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula to convert 5513 seconds into minutes 00:00:00 | Excel Worksheet Functions | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
| Minutes to seconds - how to convert? | Excel Worksheet Functions | |||
Threaded Mode
