Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time calculations
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time calculations
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 On Sep 8, 9:21*pm, NEHicks wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations | Excel Discussion (Misc queries) | |||
Time calculations | Excel Worksheet Functions | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |