Hi
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
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