Adding Time

[Guest]

Hi all ,
having a bit of a problem, i have got this spread sheet which looks somthing
like this
Name 03/07/2006 04/07/2006 05/07/2006 07/07/2006
Fallon 08:30:00 08:30:00 08:30:00 08:30:00
Lisa 08:30:00 08:20:00 08:30:00 08:15:00

now fallon is simple i can add on fingures number of hours worked to be used
for wage purpose which are 34hours.but when it comes to lisa side, i need
some sort of formulae to get that figures. any help much appreciated
thanks in advance

ali

 

[Ardus Petus]

The formula is the same for Fallon and Lisa:
=SUM(B2:E2)
format [h]mm

If you want decimal hours,type:
=SUM(B2:E2)*25
format standard

HTH