Forum Discussion
Issue Converting (Date) HH:MM:SS to Minutes
Trying to convert HH:MM:SS to minutes Some cells have dates not needed See attached example Thank you for your time
=HOUR(A1)*60 + MINUTE(A1) + SECOND(A1)/60
=HOUR(A1)*60 + MINUTE(A1) + SECOND(A1)/60
NikolinoDE
Actually sorry, because I changed the formatting
From [h]:mm:ss, to HH:MM:SS
I think I've missed some time
