Maybe if I explain what I am trying to do it will help you.
My job includes a lot of travel and I track the time at different
locations
in lump sums from arival on site to departure from site. The entervals
usaually range 1 week or less but on ocasionaly over a month and even just
over 1 year. the input data is excactly as in the origional post and
formated
as shown (date and time) I am looking for the E colum to compute total
difference. yy/mm/dd hh:mm. been doing it for years on paper, that gets
old!!
everything apears to work as I would like except that 1 month thing.
Months
need to reset after 12 and add 1 to the years.
Thank u for all the help
Fred Smith said:
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
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.
:
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.
.