I've researched through the site to see if this has been answered but with no luck after reading:
- How do I calculate a time delta in my Google Spreadsheets?
- Calculating time difference
- Calculating time worked per day
- Time duration, when converted to decimal, shows negative
In Google Sheet I'm trying to measure time accounting for a break:
When I add the first start time I get a negative:
when I add a clock out it's ok:
Starting the time back up it throws that time off:
How can I calculate the time that has an IN and OUT but omit the time when it only has an IN value?
=ROUND((ARRAYFORMULA(IF(ISBLANK(B3:C3)=FALSE,((C3-B3)*24*60/60),""))) + ARRAYFORMULA(IF(ISBLANK(D3:E3)=FALSE,((E3-D3)*24*60/60),"")),2)