| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Time Keeping
I'm trying to make a time sheet for myself but my time keeps coming up
negative. in cell a1 i have 9:00 AM (with the cell formated as time h:mm PM) and cell b1 5:00 PM (with the cell formated as time h:mm PM) and cell c1 formated as number (with formula (A1-B1)*24 . I'm getting 8 hours but it is coming out negative. so my cells look like this 9:00 AM 5:00 PM -8.00 What am i doing wrong? How can i get a positive number? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| time differences in a column | Excel Worksheet Functions | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
