View Single Post
  #1   Report Post  
Keyrookie Keyrookie is offline
Member
 
Posts: 84
Default Timesheet Issues

Greetings,

Timesheet is formatted rows as follows:
Start time in D7
Lunch "Out" in E7
Lunch "In" in F7
Stop in G7
Target in H7 (shows what time is needed to work 8 hours)
Daily H:M in I7

I'm having trouble with the formula in I7 (Daily H:M). The current formula is: =IFERROR(TEXT(E7-D7+G7-F7,"H:MM"),"")

It works fine EXCEPT if time is entered in cells D7,E7 &F7 without G7 (Stop) being populated. What's happening is this:

When D7 and E7 are populated I7 shows the time worked before Lunch. However, when time is entered into F7 (Lunch "In"), I7 goes blank. I'd like I7 to display the result of E7-D7 even if F7 is populated as well as G7-F7 so that total daily hours are displayed.

Thank you for your help,
Keyrookie