|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 3rd, 2004, 03:20 AM
|
|||
|
|||
Time Function help
Ok so i have used the function: =IF(C5-B55/24,C5-B5-1/48)
to take a half hour off a persons shift if they have worked 5 hours or more. but if a person works under five hours it will not calculate any time worked in the total column how can i get a total hours worked to be added in the totals column if less than 5 hours are worked? 
|
|
#2
February 3rd, 2004, 03:43 AM
|
|||
|
|||
|
Time Function help
=IF(C5-B55/24,C5-B5-1/48,C5-B5)
-- Regards, Peo Sjoblom wrote in message ... Ok so i have used the function: =IF(C5-B55/24,C5-B5-1/48) to take a half hour off a persons shift if they have worked 5 hours or more. but if a person works under five hours it will not calculate any time worked in the total column how can i get a total hours worked to be added in the totals column if less than 5 hours are worked?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
