| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you
"swatsp0p" wrote: Paul Sheppard Wrote: Hi Helen .............. E2 =SUM((B2-A2)+(D2-C2)) Format cells as Custom hh:mm Paul's formula will sort of return the number of hours worked. However, in the hh:mm format, it is actually shown as a time, such as 08:00 a.m.. It is difficult to do further calculations (e.g. pay calcs). You could format E2 as General and use this formula to return the actual number of hours worked: E2 =((B2-A2)+(D2-C2))*24 {the SUM function is not needed} HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=467523 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Hybrid Mode
