![]() |
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 |
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 |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com