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

  • Thread starter hard working andy w
  • Start date
H

hard working andy w

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?
 
R

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
 
P

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



Rick Rothstein (MVP - VB) said:
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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top