Issue Converting (Date) HH:MM:SS to Minutes

[Adam08780]

Trying to convert HH:MM:SS to minutes
Some cells have dates not needed
See attached example
Thank you for your time

[#2 · Accepted solution]

@Adam08780 

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

[#3]

Excellent. Cheers boss now working thank you

[#4]

@NikolinoDE 
Actually sorry, because I changed the formatting
From [h]:mm:ss, to HH:MM:SS 

I think I've missed some time

[#5]

@Adam08780 

In B2:

=1440*A2

Format B2 as General or as Number, then fill down.

[#6]

@Adam08780 

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.

[#7]

@Peter Bartholomew 

Based on the sample we shall not remove dates and take duration in minutes, thus simply

= 24 * 60 * time

@Adam08780 , 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/100

but the result shall not be used in other calculations.

[#8]

@Sergei Baklan @NikolinoDE 

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.

[#9]

@Peter Bartholomew 

Exactly