Converting 00:15:00 format into metric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=A1*24*60

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top