I am doing a time utilization. I have columns labeled case start, case end, total time, time before start, time after end, total off hours, actual time. I have to show if a room was utilized before 7am and after 17:00, and show the time that was used between 7 and 17:00. If the room was used outside of the 7-17:00 requirement the hours go in that column, and if used goes in the actual time column.
cell j2 =IF(G2<start,start-G2,0) G2=start time, and start=0.29166667
cell k2 =IF(G2>end,H2-G2,H2-end) G2=start time, H2=end time, end time=<TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=84 border=0><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 63pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ccffcc" align=right width=84 height=19>0.708333333</TD></TR></TBODY></TABLE>
Is there a way to combine the equation in cell j2 in with cell k2, so I can still have the hours worked whether it was between 7-17:00 or outside of the 10 hours.
Would appreciated any help out there.
Thank you
cell j2 =IF(G2<start,start-G2,0) G2=start time, and start=0.29166667
cell k2 =IF(G2>end,H2-G2,H2-end) G2=start time, H2=end time, end time=<TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=84 border=0><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 63pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ccffcc" align=right width=84 height=19>0.708333333</TD></TR></TBODY></TABLE>
Is there a way to combine the equation in cell j2 in with cell k2, so I can still have the hours worked whether it was between 7-17:00 or outside of the 10 hours.
Would appreciated any help out there.
Thank you