Timesheet Issues
From
Keyrookie@21:1/5 to
All on Wed Oct 2 14:22:38 2019
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
--
Keyrookie
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)