I was hoping that someone could help me out, I have two questions about a spreadsheet where I am trying to calculate how much flexi time has been accured.

So far I have managed to do this:

Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | I | |||

2 | Training Department Flexi-Time | Regular Hours: 8 | |||||||||

3 | Name | Start | Lunch Out | Lunch In | End | Total Hrs | Worked Hrs | Reg Hrs | Total Flexi Accumilated | ||

4 | Francis | 09:00 | 12:00 | 13:00 | 18:00 | 9.00 | 8.00 | 1.00 | |||

5 | Joanne | 08:45 | 12:30 | 13:15 | 16:30 | 7.75 | 7.00 | 0.75 | |||

6 | Alan | 09:15 | 13:00 | 14:15 | 20:15 | 11.00 | 9.75 | 1.25 | |||

7 | Karen | 22:00 | 23:00 | 00:30 | 07:00 | 9.00 | 7.50 | 1.50 | |||

Sheet |

The problem is that in cells f, g and h it is showing 15 mins as 25, 30 mins as 50 and 45 mins as 75.

So my first question is;

1)Is there something I can do with my formula that will make it show the correct length of time?

And my second question is;

2)Is there a formula that I can use to keep a running total of flexi in column I.

I should point out that although my sample shows all positive flexi times there will be occasions when the flexi time will be negative.

Thanks in advance for your time reading this post.