I am creating a weekly time card for our office. I have columns for start
and stop times and have successfully found the formula to get each time
segment to add up in the third column. When I try to make that 3rd column
add up the total hours for the week I can't get a sensible result.
Also, is there a simple way to have my time results automatically subtract
1/2 hour (for lunch) or do I need to split the day into morning and afternoon
as I have so far?
Any help will be appreciated.