I have cells formatted for a payroll spreadsheet to enter the in and out
times including lunch as military time. I have the daily totals working fine
but when I try to pull the weekly total it does not pull correctly because
the format is by time. I just need it to sum the value of the daily total
cells.