Date and Time problem

**E3iron** · 07-24-2009, 07:02 AM

Hi All

I need a bit of help. I got a spread sheet which i'm using the NETWORKDAYS function. I'm cutting a list of dates from a worksheet and pasting another (into say column A i.e.29/06/2009 23:59:59) in the next column is the date the event actually happened(e.g. sometimes the event is on time so 29/06/2009). In column C NETWORKDAYS i want this to be zero but i understand it's not because of the time it's 1.

Any ideas how i can remove the time form col A.

Thanks

**arthurbr** · 07-24-2009, 07:04 AM

Hy,
try a helper column containing =int(a1) and format as date ( pull down as needed)

**DonkeyOte** · 07-24-2009, 07:34 AM

NETWORKDAYS is inclusive by nature, the Time element of the datetime value will not affect output ie time is essentially ignored in NETWORKDAYS, eg:

=NETWORKDAYS(NOW(),TODAY()) will still generate 1 even though technically start > end.

**E3iron** · 07-24-2009, 10:18 AM

but when i remove the time NETWORKDAYS = 0 i.e. 26/06/09 - 26/06/09 = 0

but this willl take ages to take all the times out manually

**DonkeyOte** · 07-24-2009, 10:27 AM

I'm not sure I follow, 26/06/09 as start & end will generate NETWORKDAYS of 1 as the date range encompasses 1 working day (this was my point about the function being inclusive by nature) ... whether or not time is associated with the date values is irrelevant for this particular function.