#1   Report Post  
Old October 2nd 19, 02:22 PM
First recorded activity by ExcelBanter: Aug 2007
Posts: 79
Default Timesheet Issues


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,

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
timesheet Andy Bolger Excel Discussion (Misc queries) 2 July 19th 09 04:15 PM
Timesheet Zaf Excel Discussion (Misc queries) 8 July 11th 08 02:06 PM
Timesheet - LT AREA Excel Discussion (Misc queries) 1 November 15th 07 10:04 PM
Timesheet Construk Excel Programming 6 June 25th 07 05:03 PM
Timesheet Matt Excel Discussion (Misc queries) 3 September 15th 05 10:14 PM

All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017