| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time formatting | Excel Discussion (Misc queries) | |||
| Time Formatting | Excel Discussion (Misc queries) | |||
| Time formatting | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
