ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting 00:15:00 format into metric (https://www.excelbanter.com/excel-discussion-misc-queries/129958-converting-00-15-00-format-into-metric.html)

The Rook

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

Bob Phillips

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