Help with time formatting

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a cell that totals in hours and minutes
I need to convert that cell automatically to total in minutes
in other words I need 2:40 minutes to show as 160 minutes.
I tried formatting the cell as :mm using custom formating and it didn't work
any suggestions as to how to convert this would be very much appreciated
Tom
 
Try something like:

=IF(HOUR(A1)>0,HOUR(A1)*60,0)+ROUNDUP(MINUTE(A1),0)+1

HTH
 
Try a custom number format of:
[mm]

2:40 does mean 2 hours 40 minutes, right?
 
You must log in or register to reply here.

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

Similar Threads

converting formula for whole numbers to time 3
Adding Hours 1
Time Calculation 4
Converting dd:hh:mm to [h]:mm not working. 3
Excel formula 5
Need help calculating time 8
Calculate and Format Time 5
Formatting cells with time 3

Back
Top