| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I calculate hours using one cell only
I am trying to create a schedule that calculates hours worked in a day. I
have several restrictions in space, so would like to have one cell that shows start and end time, and a second cell that shows hours worked. For instance A1 10:00 AM - 5:00 PM B1 8 I am basically looking for the formula to put in B1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
| Cell does not calculate automaticaly | Excel Discussion (Misc queries) | |||
Threaded Mode
