R
rbarrs
I have a scheduling system that can write a file out to
excel, csv, dbase, and a couple of others. However, the
time is written as 24 hour time without a colon ex. 1:00PM
is 1300. When outlook imports the file, it makes the
appointment an all day event. If I manually change the
time to 13:00 then it will import properly. Any ideas on
how to deal with this issue? Manual changing would be too
time consuming based on the volume of appointments each
day for 6 different users.
excel, csv, dbase, and a couple of others. However, the
time is written as 24 hour time without a colon ex. 1:00PM
is 1300. When outlook imports the file, it makes the
appointment an all day event. If I manually change the
time to 13:00 then it will import properly. Any ideas on
how to deal with this issue? Manual changing would be too
time consuming based on the volume of appointments each
day for 6 different users.