Thanks:  0
Likes:  0

# Thread: h:mm to minutes - Resolved - Thanks! :)

1. It takes so little to stump me in excel these days. I've calculated the amount of time a person works in a day i.e. 8:45 (formatted h:mm). Now I need help converting those 8h 45m to 525m.

I searched prior posts but couldn't find my solution. I fear it's there somewhere and I overlooked it.

_________________
Rita~~

"Baseball is like church, many attend, few understand." Leo Durocher

[ This Message was edited by: LuvlyRitaa on 2002-05-08 20:29 ]

2. G'day,

Have you tried multiplying the cell by 1440 and formatting the cell as a number? That should give you the number of minutes in a decimal format (e.g 8.5 = 8 minutes 30 seconds).

3. Hi Rita,
Assuming it is a valid Excel time the function hour() will return the hours and minute() will return the minutes.

=minute(A1)+60*hour(A1)

Of course this cell must not formated as time, but general or number.

4. On 2002-05-08 18:19, LuvlyRitaa wrote:
It takes so little to stump me in excel these days. I've calculated the amount of time a person works in a day i.e. 8:45 (formatted h:mm). Now I need help converting those 8h 45m to 525m.

I searched prior posts but couldn't find my solution. I fear it's there somewhere and I overlooked it.

Hi Rita just Custom format the entry 8:45 as [mm] and you will see the selult in minutes displayed as 525

5. Y'all are the BEST!

Problem solved

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•