Thanks, but this didn't worked I'm getting 4:30 as the answer. But its ok, I
got my answer from others already. thanks again

"Bob Phillips" wrote:

Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RICK" wrote in message
...
I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY SUCH
AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE
ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30