Baryonic Lord
New Member
- Joined
- Feb 23, 2018
- Messages
- 1
Hello All,
How can I show the value of the last cell in column H as soon as its dependent cells (column C is Start Time, column D is when one clocks out for lunch, column E is when they came back from lunch, and column F is their total lunch time taken)?
column B is the date
column C is Start Time. Entered manually.
column D is when one clocks out for lunch. Entered manually.
column E is when they came back from lunch. Entered manually.
column F is their total lunch time taken. Formula here is "=TEXT(E1346-D1346,"hh:mm")"
column G is not used
column H is when their full work day ends. It's 9 hours most days and 8 hours every other Friday. Formula here is "=C1346+TIME(9,0,)+F1346"
column I is the actual time one clocks out for the day. Entered manually.
column J is the actual time I worked that day. Formula is "=TEXT((I1346-C1346)-F1346,"h:mm")"
column K is the same value in column J but in decimal. Formula is "=HOUR(J1346)+MINUTE(J1346)/60"
The entire row is empty except for the date (column B). Values are computed from left to right as they are filled in during the workday.
Up until yesterday column H remained empty until column C had a value and column F could be calculated.
Today, I enter my start time in column C, my lunch out in column D, and my lunch in in column E. Column H stays empty instead of calculating a value.
I don't have conditional formatting anywhere in the workbook. The formulas used do not show or hide any text.
Any tips or assistance would be GREATLY appreciated!
Excel 2016 (Windows) 32 bit
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
How can I show the value of the last cell in column H as soon as its dependent cells (column C is Start Time, column D is when one clocks out for lunch, column E is when they came back from lunch, and column F is their total lunch time taken)?
column B is the date
column C is Start Time. Entered manually.
column D is when one clocks out for lunch. Entered manually.
column E is when they came back from lunch. Entered manually.
column F is their total lunch time taken. Formula here is "=TEXT(E1346-D1346,"hh:mm")"
column G is not used
column H is when their full work day ends. It's 9 hours most days and 8 hours every other Friday. Formula here is "=C1346+TIME(9,0,)+F1346"
column I is the actual time one clocks out for the day. Entered manually.
column J is the actual time I worked that day. Formula is "=TEXT((I1346-C1346)-F1346,"h:mm")"
column K is the same value in column J but in decimal. Formula is "=HOUR(J1346)+MINUTE(J1346)/60"
The entire row is empty except for the date (column B). Values are computed from left to right as they are filled in during the workday.
Up until yesterday column H remained empty until column C had a value and column F could be calculated.
Today, I enter my start time in column C, my lunch out in column D, and my lunch in in column E. Column H stays empty instead of calculating a value.
I don't have conditional formatting anywhere in the workbook. The formulas used do not show or hide any text.
Any tips or assistance would be GREATLY appreciated!
Excel 2016 (Windows) 32 bit
B | C | D | E | F | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|
1343 | 2-19-2018 | 7:01 AM | 11:19 AM | 12:28 PM | 01:09 | 4:10 PM | 5:32 PM | 9:22 | 9.37 |
1344 | 2-20-2018 | 6:27 AM | 11:38 AM | 12:24 PM | 00:46 | 3:13 PM | 5:03 PM | 9:50 | 9.83 |
1345 | 2/21/2018 | 7:30 AM | 11:28 AM | 11:57 AM | 00:29 | 4:59 PM | 5:17 PM | 9:18 | 9.30 |
1346 | 2/22/2018 | 6:06 AM | 11:20 AM | 12:30 PM | 01:10 | 4:16 PM | 4:53 PM | 9:37 | 9.62 |
1347 | 2/23/2018 | 7:52 AM | 11:15 AM | 11:45 AM | 00:30 | ||||
1348 | 2-26-2018 | ||||||||
1349 | 2-27-2018 | ||||||||
1350 | 2-28-2018 | ||||||||
1351 |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Times
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>