Forum Discussion
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
=HOUR(A1)*60 + MINUTE(A1) + SECOND(A1)/60
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.