time calculations

  • Thread starter Thread starter NEHicks
  • Start date Start date
N

NEHicks

I need to count the total hours by unit in a spreadsheet. One column is for
a start time, the next column is an end time and this is the formula that I
use to calculate the number of hours on a 24 hour clock:
=MOD(G107-F107,1)-((MOD(G107-F107,1)*24>8)*30/1440)

I need to look at the whole pay period and calculate the hours by ward.
Ward = C column
# of hours worked = H column (where formula is)
I have tried using =SumIF($C$5:$C$25, "3A", $H$5:$H$25). It doesn't work.
I then tried to use the TimeValue formua and couldn't get that to work. Help.
 
I don't know what "It doesn't work" means - how does it not work? Do
you get errors, zero, answer too large or too small ??

The SUMIF formula looks fine, as long as your Ward is called 3A, but
perhaps you might have entered it within your data in column C as
3A<space>. To check for that put wildcards within the quotes, like
this:

=SUMIF($C$5:$C$25,"*3A*",$H$5:$H$25)

If this doesn't work, tell me what happens.

Hope this helps.

Pete
 
Back
Top