| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting 00:15:00 format into metric
I currently have operation times against specific operations in the 00:15:00
format (ie 15 mins). How can I convert this into metric minutes ie 00:15:00 = 15 or 01:15:00 = 75? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting 00:15:00 format into metric
=A1*24*60
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Rook" <The wrote in message ... I currently have operation times against specific operations in the 00:15:00 format (ie 15 mins). How can I convert this into metric minutes ie 00:15:00 = 15 or 01:15:00 = 75? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting US Date Format | Excel Worksheet Functions | |||
| converting excel to text or prn, losing format | Excel Discussion (Misc queries) | |||
| Converting data Format | Excel Discussion (Misc queries) | |||
| Converting DD/MM/YYYY format into text MMYYYY | Excel Discussion (Misc queries) | |||
| converting xls format into csv format | Excel Discussion (Misc queries) | |||
Linear Mode
