| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hrs
How do you make a formula that sais that an employee started work at 4am and
finished at 1030 am i need the answer to 6.5 hrs. The problem would read say in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the amount of hrs as 6.5 not 6.3? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
| Adding values from previous worksheets | Excel Worksheet Functions | |||
| help neede with adding times | Excel Discussion (Misc queries) | |||
| problem adding | Excel Discussion (Misc queries) | |||
| adding cells that contain formulas that have returned error messag | Excel Worksheet Functions | |||
Threaded Mode
