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

Adam08780
Copper Contributor
Apr 28, 2024
NikolinoDE
Actually sorry, because I changed the formatting
From [h]:mm:ss, to HH:MM:SS
I think I've missed some time

Example Corrected.xlsx9 KB
- HansVogelaar
  MVP
  Apr 28, 2024
  Adam08780
  
  In B2:
  
  =1440*A2
  
  Format B2 as General or as Number, then fill down.
Adam08780
Copper Contributor
Apr 28, 2024
Excellent. Cheers boss now working thank you

Resources