| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss)
Excelent..........
You don't know the time you have saved me. Cheers. "daddylonglegs" wrote: You need to change the actual values. This conversion is actually division by 60 so you could follow this procedure put 60 in any empty cell copy that cell select range of times to convert Edit Paste Special Divide format times as mm:ss -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522892 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert whole numbers representing seconds to mm:ss | Excel Worksheet Functions | |||
| How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
| How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
| How to convert 250minutes into the format of hh:mm:ss in Excel? | Excel Worksheet Functions | |||
| how to convert 357646 seconds into hh:mm:ss format? | Excel Worksheet Functions | |||
Threaded Mode
