| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 72132 | 2006-08-31 09:01:00 | Excel question. Entering times | wooda2 (4837) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 481681 | 2006-08-31 09:01:00 | Is it possible to enter times in Excel using decimal points as separators instead of colons. I am trying to make a timesheet and it is a pain using the colons | wooda2 (4837) | ||
| 481682 | 2006-08-31 09:23:00 | Excel doesn't handle time very well Colons are the way to go. | DeSade (984) | ||
| 481683 | 2006-08-31 11:46:00 | not ideal, but why not put the times in using full stops and then when you are done with the times use the Replace function and replace the full stops with colons? Or is the table to be used on an ongoing basis? | Sick Puppy (6959) | ||
| 481684 | 2006-08-31 19:21:00 | While you enter times using a colon, Excel is actually storing this as a number. Days are stored as whole numbers while times are stored as a fraction of a day. For example, enter 08:00 into a cell then go to Format | Cells from the menu and choose the number category. You will see that the number result is 0.33 being 1/3rd of a day. Your going to have problems entering using decimals as 8.00 would be considered as 8 days and 0 hours to Excel if you converted this to a time after entering. That said, you could use formulas to convert back to what you require. If you dont mind adding a macro to the workbook then Chip Pearsons code may help with quick entry of times... www.cpearson.com regards, Graham |
Parry (5696) | ||
| 481685 | 2006-09-01 06:30:00 | Thanks to all who helped. The macro does the trick | wooda2 (4837) | ||
| 1 | |||||