Hey everyone!
I have this spreadsheet that track when I get into to work and when I leave. The "Diff" row is where I want to insert a formula that will take the total amount of time that I've worked in the day and subtract 8 and half hours from it. So for example, under "10/16" I want the formula to output -30 or -.5 as the Total hours worked that day was less than 8 and half (8 hours worked that day).
I thought this would be simple but apparently you can't show a negative value in Time format which is fine but when you use a Number format the number is between 0 and .9999 so I can't interpret how many hours or minutes I've worked less or extra in that day.
Feel like this is a simple solution but I'm blanking on this hard for some reason. Can anyone help?
Thanks in advance!
View attachment Timesheet.xlsx
I have this spreadsheet that track when I get into to work and when I leave. The "Diff" row is where I want to insert a formula that will take the total amount of time that I've worked in the day and subtract 8 and half hours from it. So for example, under "10/16" I want the formula to output -30 or -.5 as the Total hours worked that day was less than 8 and half (8 hours worked that day).
I thought this would be simple but apparently you can't show a negative value in Time format which is fine but when you use a Number format the number is between 0 and .9999 so I can't interpret how many hours or minutes I've worked less or extra in that day.
Feel like this is a simple solution but I'm blanking on this hard for some reason. Can anyone help?
Thanks in advance!
View attachment Timesheet.xlsx