| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting time cell
I have a time sheet that calculates time worked. I have the input cells for
the time in, lunch out, etc. They are all formatted Time - 1:30PM. The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the calculations are correct. How do I format the cells so that I don't have to enter the seconds? oldjay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Formatting a cell to calculate time. | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| multiplycation of money cell and time cell | Excel Worksheet Functions | |||
Threaded Mode
