date and time difference
E got cut off should be at the end.
"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.
|