adding cells in time format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was looking for some ideas on how to add up cells that contain time
vaulues. I work with peoples shifts and hours and I want to be able to add up
in any given day, how many 7-330 shifts, 8-430...shifts that I have on each
day. How can I get Excel to add down each column representing each day of the
week giving me the number of shifts per day? Thanks.
 
It would help to see some example data and results.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to distribute 18 staff member on 3 shifts 0
Adding up total hours worked on employee schedule using various criteria 0
Calculation Time 2
Inserting cells (shift cells right) using macro 0
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Determine if night shift by start & end time 2
Vlookups using 2 Values 2
Workflow Roster 5

Back
Top