Im currently trying to build a spreadsheet to record times worked for a particular month.

The guidlined hours for the day are 8 hours but the employees have the option of working both over and under that time. For example if the emplyee worked 08:30 hours that day he would build up 00:30 minutes flexi-time, if the employee worked 07:30 he would have lost - 00:30 minutes flexi-time

Iv currently built a spreadsheet which includes

Time-In Time-Out Days hours Flexi carried forward Flexi built

The trouble is when i use the formular =(days hours-8) to work out the flexi carried forward. If this is a minus value the time will not be displayed.

Another problem i have is that i need to accumulate the flexi time in the flexi built. This is based on the flexi carried forward e.g.

Flexi Carried forward

+00:30

+00:15

-00:50

Therefor flexi built would display

Flexi Built

+00:30

+00:45

-00:05

Is this possible to acheive in Excel, if so i would be gratefull for any help

Many thanks