Hi
you just have to describe HOW you want to round your values. The value
Excel displays is the correct one. Now just check with HR how they
round times

--
Regards
Frank Kabel
Frankfurt, Germany

"NeedhelpinTennessee" <(E-Mail Removed)>
schrieb im Newsbeitrag
news:39DEB460-EB7D-4414-BC97-(E-Mail Removed)...
> Thanks everyone. I think it is possible that because the payroll
department
> calculates the times worked into 100's, it is throwing everything
off. And
> Lord knows I am surely unsure how to get the cells to calculate into
100's or
> if it is even possible??
>
> "Frank Kabel" wrote:
>
> > Hi
> > there's no rounding error. The total time worked is (in time
format):
> > 07:39 hours - 00:51 hours = 06:48 hours.
> > If you convert now 06:48 in decimal format the result is 6.80 (as
48
> > minutes are equivalent to 0.8)
> >
> > So there's no rounding error :-)
> >
> >
> > --
> > Regards
> > Frank Kabel
> > Frankfurt, Germany
> >
> > "NeedhelpinTennessee"
<(E-Mail Removed)>
> > schrieb im Newsbeitrag
> > news:E17478A0-A435-4C6A-9645-(E-Mail Removed)...
> > > the contents in C2 =7:01 AM (start time)
> > > D2 =1:03 PM (lunch out)
> > > E2 = 1:54 PM (lunch in)
> > > F2 =2:40 PM (time left)
> > >
> > > G2= =-(F2-C2+(F2<C2))*24 (total hours) (total hours =7.65
> > >
> > > H2==((F2-C2+(F2<C2))-(E2-D2+(E2<D2)))*24 (hours worked) (=6.78)
> > which keeps
> > > rounding to 6.80.
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Dave R." wrote:
> > >
> > > > What are the contents of these F2, C2, E2, D2?
> > > >
> > > >
> > > >
> >
> >

See my reply to your post on 9/27.

Biff

>-----Original Message-----
>Thanks everyone. I think it is possible that because the
payroll department
>calculates the times worked into 100's, it is throwing
everything off. And
>Lord knows I am surely unsure how to get the cells to
calculate into 100's or
>if it is even possible??
>
>"Frank Kabel" wrote:
>
>> Hi
>> there's no rounding error. The total time worked is (in
time format):
>> 07:39 hours - 00:51 hours = 06:48 hours.
>> If you convert now 06:48 in decimal format the result
is 6.80 (as 48
>> minutes are equivalent to 0.8)
>>
>> So there's no rounding error :-)
>>
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>> "NeedhelpinTennessee"
<(E-Mail Removed)>
>> schrieb im Newsbeitrag
>> news:E17478A0-A435-4C6A-9645-
(E-Mail Removed)...
>> > the contents in C2 =7:01 AM (start time)
>> > D2 =1:03 PM (lunch out)
>> > E2 = 1:54 PM (lunch in)
>> > F2 =2:40 PM (time left)
>> >
>> > G2= =-(F2-C2+(F2<C2))*24 (total hours) (total hours
=7.65
>> >
>> > H2==((F2-C2+(F2<C2))-(E2-D2+(E2<D2)))*24 (hours
worked) (=6.78)
>> which keeps
>> > rounding to 6.80.
>> >
>> >
>> >
>> >
>> >
>> >
>> > "Dave R." wrote:
>> >
>> > > What are the contents of these F2, C2, E2, D2?
>> > >
>> > >
>> > >
>>
>>
>.
>