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)*248)*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.