Rounding problem with time

[rgholmes08]

Hi all,

I am having an issue with time rounding. The columns consist hours/days for a 7 day week. So 8/3/14 12:00 AM, 8/3/14 1:00 AM, 8/3/14 2:00 AM..... ect.

If I manually enter in every date/time my formula works flawlessly. I don't really wanna enter 168 date/times to fill out my week schedule but when I try to enter in 2 date/times then drag across the formula does not work. I notice a dragged time/date rounds differently than if I manually enter one.

Is there a way to not manually enter in every date but avoid the rounding issue?

The formula isn't the issue as it just states IF($A2=B$1,1)

[Punnam]

Hi,

Sample workbook without any confidential data .

Punnam

[martindwilson]

trying again last post was wrong
ok try
a1=08/03/2014 00:00:00
a2=ROUND(A1*24+1,0)/24 fill down A2

[cbatrody]

Or,

A1: 08/03/2014 0:00
A2: =A1+1/24

and drag down.....

[martindwilson]

that doesnt work cbatrody
a1= 08/02/2014 00:00
then a168 =14/02/2014 23:00
in c168 put a168=b168 and type in 14/02/2014 23:00 in b168
you get false

[cbatrody]

Yes Martin, you are right. Thanks for bringing that up.