Forum Discussion

Copper Contributor

Apr 28, 2024

Solved

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

Example.xlsx10 KB

Formulas and Functions

NikolinoDE
Apr 28, 2024
Adam08780
=HOUR(A1)*60 + MINUTE(A1) + SECOND(A1)/60
Example (2).xlsx10 KB

Platinum Contributor

Apr 28, 2024

=HOUR(A1)*60 + MINUTE(A1) + SECOND(A1)/60

Example (2).xlsx10 KB

Copper Contributor

Apr 28, 2024

Excellent. Cheers boss now working thank you

Resources