Time is a wonderful thing......only I have spent ages trying to sort this problem out with no success, so would be really grateful for some help from the experts please ...

I have a sheet which is designed as a "work timesheet",

Column D is a start time Eg 09:00
Column E is the finish time EG 16:45

Column G is is a formula to calculate the number of hours worked " =(E1-D1)*24 " which from the above example gives a return of 7.75 Hours.

The problem I am having is working out a formula to round the total minutes worked up to the next half hour eg 7.51 or above rounded up to 8.00, or if the total was 7.49 or below for it to be rounded up to 7.5

The actual hours do vary so I guess its just the minutes I need to work on??

Many thanks for any help anyone can offer me.