Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Problem
I've got an excel spreadsheet that tracks attendance (time in/out). We work 8 or 10 hour days depending on the shift. We are required to be as close to 0 hrs over/under at the end of each month however we sometimes carry a balance of x amount of minutes. My goal is to create a cell that you can input your time over/under into which represents any overage/underage from the previous month. This cell will then add into the cumulative +/- total for the current month so that you know when to clock out for the day. My Cumulative +/- cell has this formula =SUM($F$16:F$46+D8) Where column F represents a time value of Time Out - Time In and D8 represents the previous months' time +/- in h:mm format The formula isn't working and I don't know why...... -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=383665 |
#2
|
|||
|
|||
=sum(f$16$:f$46$)+d8. HTH
-- Sincerely, Michael Colvin "B. Baumgartner" wrote: I've got an excel spreadsheet that tracks attendance (time in/out). We work 8 or 10 hour days depending on the shift. We are required to be as close to 0 hrs over/under at the end of each month however we sometimes carry a balance of x amount of minutes. My goal is to create a cell that you can input your time over/under into which represents any overage/underage from the previous month. This cell will then add into the cumulative +/- total for the current month so that you know when to clock out for the day. My Cumulative +/- cell has this formula =SUM($F$16:F$46+D8) Where column F represents a time value of Time Out - Time In and D8 represents the previous months' time +/- in h:mm format The formula isn't working and I don't know why...... -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=383665 |
#3
|
|||
|
|||
If you sum ranges and individual cells you need to separate them with a comma
(not +).So your formula would be: =SUM($F$16:F$46,D8) Or equally, =SUM($F$16:F$46)+D8 would do the same, kirsty "B. Baumgartner" wrote: I've got an excel spreadsheet that tracks attendance (time in/out). We work 8 or 10 hour days depending on the shift. We are required to be as close to 0 hrs over/under at the end of each month however we sometimes carry a balance of x amount of minutes. My goal is to create a cell that you can input your time over/under into which represents any overage/underage from the previous month. This cell will then add into the cumulative +/- total for the current month so that you know when to clock out for the day. My Cumulative +/- cell has this formula =SUM($F$16:F$46+D8) Where column F represents a time value of Time Out - Time In and D8 represents the previous months' time +/- in h:mm format The formula isn't working and I don't know why...... -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=383665 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
rounding time question | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Problem with time calc | Excel Worksheet Functions |