convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

[Guest]

How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?

 

[Guest]

A custom format of

[m]

Mike

 

[Guest]

Alternatively

=(A1-A2)*24*60

Mike

 

[Leo Rod]

To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.

 

[Rick Rothstein \(MVP - VB\)]

To convert it to a value:

=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.

While Mike H's formula (=A1*60*24) would be the quickest method (although I
would change the 60*24 in it to 1440 to save a multiplication), if you
wanted to examine alternate methods, then here is another one to consider
(shorter than yours and one function call less)...

=--TEXT(A1,"[m]")

Rick

 

[Peo Sjoblom]

I think Mike used A1*60*24 since it makes more sense than 1440 or 86400 with
seconds

I mean, since we are working with time values if you convert 55000 seconds
into Excel time values I think =55000/24/60/60 makes more sense than
=55000/86400


--
Regards,

Peo Sjoblom

To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.

While Mike H's formula (=A1*60*24) would be the quickest method (although
I would change the 60*24 in it to 1440 to save a multiplication), if you
wanted to examine alternate methods, then here is another one to consider
(shorter than yours and one function call less)...

=--TEXT(A1,"[m]")

Rick

 

[Rick Rothstein \(MVP - VB\)]

I think Mike used A1*60*24 since it makes more sense than 1440 or 86400

with seconds

I mean, since we are working with time values if you convert 55000
seconds into Excel time values I think =55000/24/60/60 makes more sense
than =55000/86400

No, I understand that... I just meant that I would have used 1440 in the
formula and put an explanation in the text telling the OP where the number
came from. Sorry for not being more clear about that.

Rick