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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|