| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when i enter time in cell it changed, why?
When I entered time (45:32) in cell (total No. of working hour in week), its
changed into 14/01/1900 11:44:00 AM, please guide me to solve this problem and tell me how to add time? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when i enter time in cell it changed, why?
Formatcellnumbercustom [hh]:mm
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Hassan" <Hassan @discussions.microsoft.com wrote in message ... When I entered time (45:32) in cell (total No. of working hour in week), its changed into 14/01/1900 11:44:00 AM, please guide me to solve this problem and tell me how to add time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sound+color alert if cell changed in another worksheet | Excel Discussion (Misc queries) | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
| multiplycation of money cell and time cell | Excel Worksheet Functions | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
