Working with time in hours; how can i get a negative or total value?

[smithjon]

Hello, firstly, please see attached my spread sheet -
i am using this to record staffs working hours in the week (cell F19- total) and this is compared against their contracted hours in cell A2.
in cell G19, the vlaue here displays the difference of time between hours worked in the week and their contractual hours.
This value is used to determine how much toil they are owed to or by the company.

with this data, in cell G/H/I 4, i wanted a summary box to be able to work out what someones current value of toil is from the data entered over the year as in total there will be 52 boxes to tally up.

I am aware that excel will not display a negative time however there must be someway of doing what i need!
if someone hs a negavite toil how am i going to reflect this in the spreadsheet, i need the balances to be displayed in hours and minutes also and not decimal values please.
the easier to use and read then the better.

regards,

[daddylonglegs]

Excel can display negative time values.....but you need to switch to 1904 date system

File > Excel Options > Advanced > When calculating this workbook > tick "1904 date system"

Note that if you change that then all dates in the workbook will change to dates 4 years later (!) so you will have to reset those - doesn't look like you have (m)any dates in your attached version, though.......

[popipipo]

Or with CF you say/show it is a negative time

[smithjon]

Thank you both for that, they both work,

popipopo, how might i incorporate these runnning totals into some kind of formula in my summary box at the top of the page please?
obviously if this sheet was over a yearly period i would need something to show exactly what someones toil is or isn't without having to manually work this out?

[popipipo]

Divide it into 2 cells/columns 1 for + hours an 1 for - hours