| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maxium hours that excel accept
Hi. I inserting a total of horas of 35000 but the excel is not accpting this
total number of hours. I think that the max that is acceptiing is 9000 hours. How can I make it to accept 35000 hours, or more then 9000hours. Regards, Marco |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maxium hours that excel accept
I think the limit when entering it in Excel date/time format is 10000
hours. You will need to work in normal number format if you want to record such large numbers, so you would enter the hours as 35000.5 meaning 35,000 hours and 30 minutes. Hope this helps. Pete On Nov 7, 9:34 am, Marco wrote: Hi. I inserting a total of horas of 35000 but the excel is not accpting this total number of hours. I think that the max that is acceptiing is 9000 hours. How can I make it to accept 35000 hours, or more then 9000hours. Regards, Marco |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maxium hours that excel accept
Or you could use =35000.5/24, and format as [h]:mm:ss
-- David Biddulph "Pete_UK" wrote in message ups.com... I think the limit when entering it in Excel date/time format is 10000 hours. You will need to work in normal number format if you want to record such large numbers, so you would enter the hours as 35000.5 meaning 35,000 hours and 30 minutes. Hope this helps. Pete On Nov 7, 9:34 am, Marco wrote: Hi. I inserting a total of horas of 35000 but the excel is not accpting this total number of hours. I think that the max that is acceptiing is 9000 hours. How can I make it to accept 35000 hours, or more then 9000hours. Regards, Marco |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I have Excel accept date in format dd/mm/yy ? | Setting up and Configuration of Excel | |||
| maxium worksheet on a workbook? | Excel Worksheet Functions | |||
| Why won't excel accept my password? | Excel Discussion (Misc queries) | |||
| Excel will not accept data to add a column | New Users to Excel | |||
| Finding the maxium value of a column | Excel Worksheet Functions | |||
Hybrid Mode
