Thread
:
Hours and Minutes to minutes
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Steved
Posts: n/a
Hours and Minutes to minutes
Hello From Steved
=HOUR(A1)*60+MINUTE(A1)
I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
should be 407. I formatted the cell mm
Thankyou.
Reply With Quote
Hours and Minutes to minutes