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
- Excellent. Cheers boss now working thank you
NikolinoDE
Actually sorry, because I changed the formatting
From [h]:mm:ss, to HH:MM:SSI think I've missed some time
Slight differences in that I never use relative references, always names and array formulas.
= 24 * 60 * MOD(times, 1)where 'times' is a named range containing the time durations. The MOD function removes entire days if that is required.
Based on the sample we shall not remove dates and take duration in minutes, thus simply
= 24 * 60 * timeAdam08780 , I guess this misprint, in the sample 121:02:08 is converted to 7262.08, i.e. to 7262 minutes and 08 seconds. Actually that shall be 7263.13 minutes. We may convert to such strange format with
=INT( 24 * 60 * time) + MOD(24 * 60 * time,1)*60/100but the result shall not be used in other calculations.
Fair enough. I was looking at Nico's solution and set out to replicate that result.
Looking at your post reminds me of another way of performing the somewhat strange calculation
= DOLLARFR(24*60*timeInterval, 60)The use the result within further calculation requires DOLLARDE.
I always found the functions distinctly strange but maybe that stems from having a technical background.
