# Trying to do a round function but unable to get it to function

Frank Kabel
Guest
Posts: n/a

 29th Sep 2004
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?
> > > >
> > > >
> > > >

> >
> >

Biff
Guest
Posts: n/a

 30th Sep 2004

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?
>> > >
>> > >
>> > >

>>
>>

>.
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?QnVk?= Microsoft Excel Programming 5 18th Aug 2006 05:39 AM =?Utf-8?B?dG1laXN0ZXI=?= Microsoft VB .NET 5 29th Nov 2004 10:55 PM freimc Microsoft Excel Worksheet Functions 3 18th May 2004 11:36 AM Nick Microsoft Excel Worksheet Functions 2 7th Apr 2004 12:57 PM mikeb Microsoft Dot NET Framework 0 20th Jan 2004 01:30 AM

Features