View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How do you convert decimal in to numbers

No, ignore it.

--
HTH

Bob Phillips

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

"RICK" wrote in message
...
What do you mean by this
(replace somewhere in email address with gmail if mailing direct) is this
for me, if yes, how to do it.

"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