| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem adding time
Hello
I have a column with cell format set to time (13:00), but when I tried to add to get the total number of hours:mins, it gave me wrong sum. I dont know what is the problem. The target cell's format is also set to time(13:00). Any thoughts on this would be appreciated. Thanks Kappa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem adding time
Format Custom as [h]:mm
Or provide more details, like the input values, your formula and the result you got -- Kind regards, Niek Otten "Kappa" wrote in message oups.com... Hello I have a column with cell format set to time (13:00), but when I tried to add to get the total number of hours:mins, it gave me wrong sum. I dont know what is the problem. The target cell's format is also set to time(13:00). Any thoughts on this would be appreciated. Thanks Kappa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time problem or excel mistake | Excel Worksheet Functions | |||
| Adding small units of time and entering them quickly | Excel Discussion (Misc queries) | |||
| problem in date time picker size | Excel Discussion (Misc queries) | |||
| Problem with adding time values | Excel Worksheet Functions | |||
| 1/0/1900 10:18:48 AM Time problem | Excel Worksheet Functions | |||
Linear Mode
