Help with time formatting
 

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

Help with time formatting
 

Try something like:

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

HTH


"Tom" wrote:

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

Help with time formatting
 

Try a custom number format of:
[mm]

2:40 does mean 2 hours 40 minutes, right?


Tom wrote:

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

--

Dave Peterson

Help with time formatting
 

=A1*24*60 and format as number or general, not as time.
--
David Biddulph

"Tom" wrote in message
...
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