How do I sum the value of a range of cells without pulling any ce.
 

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.

How do I sum the value of a range of cells without pulling any ce.
 

If the daily totals are in HH:MM form, just format the weekly totals as
[h]:mm

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"c_foskey_22" wrote in message
...
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.

How do I sum the value of a range of cells without pulling any
 

That worked great, thanks


"Bob Phillips" wrote:

If the daily totals are in HH:MM form, just format the weekly totals as
[h]:mm

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"c_foskey_22" wrote in message
...
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.