View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
 
Posts: 334
Default How do you convert decimal in to numbers

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