Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |