if a2 isthe start time and B2 is end time in c2 type thisformula
format C2 as time
your can copy this file down keeping the format in column C as Time
"Allan" wrote in message
> As a novice to Excel I am trying to work out a formula to calculate hours
> minutes worked each day (start and finish) and then at the end of the week
> add these times to calculate weekly salary.