trzaskowski
New Member
- Joined
- Jan 8, 2005
- Messages
- 3
can access handle time formats either
hh:mm:ss
or just
mm:ss
like excel
I've got data in following
day: Monday
Date 01/03/2005
time: 07:00 denoting 7am
avg talk time: 01:30 denoting 1 minute 30 seconds
this database was created by someone else so i either need to scrape it figure out how to work in it. I need to add all the avg talk time together,
if i can replace all the cells 01:30 with 00:01:30 that would be okay too, but I don't see the hh:mm:ss format besides just using text
Thanks
hh:mm:ss
or just
mm:ss
like excel
I've got data in following
day: Monday
Date 01/03/2005
time: 07:00 denoting 7am
avg talk time: 01:30 denoting 1 minute 30 seconds
this database was created by someone else so i either need to scrape it figure out how to work in it. I need to add all the avg talk time together,
if i can replace all the cells 01:30 with 00:01:30 that would be okay too, but I don't see the hh:mm:ss format besides just using text
Thanks