When you display yy/mm/dd (with or without the time), months start at 1.
There is no month zero. This is just the way months are displayed. You
cannot use a date format if you want to have a month zero.

If you want to get around this, give us sample results, and what you would
like displayed. In particular, how many days do you expect your "months" to
have.

Regards,
Fred

"Stumped" wrote in message
...
Update:
after testing various times and dates the hours seem to be counting
correctly (adding 1 day for every 24) even in the E5 cell without the "
[ ]
"so I am leaving them out of the formating.
Everthing seems to be ok except the additional 1 month when there has not
been 1 month pass. In the E5 cell the "false" 1 month is not added to the
sum
but is still shown. let me know if I confuseing you. Thank u both for the
time and effort.

"Stumped" wrote:

A | B | C | D
|
E
1| 12/09/04 | 3:45 PM | 05/15/06 | 1:00 AM |
2|
3|
4|
5|

Log for short and long term visits. Colums A&B being start date and time
in
that format Colums C&D being end date and time.
Need E1 to = total duration in Format YY/MM/DD HH:MM
And E5 to = total of E1:E4 in the Format YY/MM/DD HH:MM
Please help, been at this problem for weeks now.