I need to modify the formulas for the daily totals in column D (file attached) so that if each day's total hours is 6 hours or more, 30 minutes is deducted in the total displayed. What formula should I use?
I need to modify the formulas for the daily totals in column D (file attached) so that if each day's total hours is 6 hours or more, 30 minutes is deducted in the total displayed. What formula should I use?
Try this:
, formatting cells to hh:mm.Please Login or Register to view this content.
That worked. Thanks for your help.
You're welcome & thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks