work week

Hello. I currently have conditional formatting to highlight a cell (E6) blue if the date in that is todays date, which works well. I now want to add conditional formatting that would highlight a cell (E6) if the date in that cell takes place during the current work week, and have it stop...

I have a list days and clock in and out times. I would like to calculate the total number of hours worked in a work week. The work week begins midnight Sunday and ends at 11:59:59 Saturday. The punch in and out times are in military format. Employees don't work every day of the week. My problems...

I have a chart that contains time per task and then adds the tasks for a grant time total. Example: 0:05 wash hands 0:10 brush teeth 0:20 shave 0:35 - total morning prep time In my chart the total time is currently 63:25:00 or 2d 15h 25m I want to break this down into a number that can be...