| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Sheets
Hi, I want to calculate empoyee time sheets in excel. I want ot enter a
start time and a finish time and get the total hours worked. If A is start and B is finish it is a simple B - A but you run into a problem for people who work across the midnight hour. How do I get around this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Sheets
=MOD(B1-A1,1)
HTH Bob "Malone" wrote in message ... Hi, I want to calculate empoyee time sheets in excel. I want ot enter a start time and a finish time and get the total hours worked. If A is start and B is finish it is a simple B - A but you run into a problem for people who work across the midnight hour. How do I get around this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Sheets
thanks
"Bob Phillips" wrote: =MOD(B1-A1,1) HTH Bob "Malone" wrote in message ... Hi, I want to calculate empoyee time sheets in excel. I want ot enter a start time and a finish time and get the total hours worked. If A is start and B is finish it is a simple B - A but you run into a problem for people who work across the midnight hour. How do I get around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| time sheets | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Worksheet Functions | |||
| Time Sheets | Excel Worksheet Functions | |||
| Time Sheets | Excel Worksheet Functions | |||
Linear Mode
