Formula

Can you please explain this formula in column H?

screenshot.png
mustish1Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The reason it is a day is that date/times are stored as a number of days from a base date using the whole number portion of the number, and the time using the decimal portion.

So quite often, you see adjustments to date/times like this.

Jim
1
 
Wayne Taylor (webtubbs)Commented:
=IF(F23<D23, F23+1, F23)-D23

This looks to see if the time in column F is less than the time in column D. If it is, that means the time in column F is actually from yesterday and would result in a negative time span. To account for this, a single day is added to the time in column F which ensures it is after the time in column D.
1
 
mustish1Author Commented:
Thank You.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.