Hi all
Is there a sumif subtotal forumula? I would like sum the total time greater than 6:30 AM in a column,
but the total should change after filtering the respective projects id.
if the checkin time is greater than scheduled checkin then the output should the total sum of the more than scheduled checkin time.
Project ID Check in Check Out Scheduled Check IN
1 6:02 AM 11:01 AM 6:30 AM
1 6:54 AM 12:01 AM 6:30 AM
2 6:01 AM 10:59 AM 6:30 AM
2 6:36 AM 9:26 AM 6:30 AM
3 6:33 AM 11:02 AM 6:30 AM
3 6:22 AM 11:02 AM 6:30 AM
3 6:40 AM 10:31 AM 6:30 AM
Example:
if i filter project id 3 then i should get a sum value of 0.10 minutes.
Thank you.
Bookmarks