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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks