Time conversion from military to clock time

Renee Zarazinski

I have two fields Time-in & Time-out that are in military time. I have to calculate the difference (to get the total amt. of time spent working) then show the time as clock time. I've only been working with Access for 2 weeks and am not at the level yet to do this.

FishVal

Hi, Renee.

Try something like this.

Expand|Select|Wrap|Line Numbers

Format([Time-out]-[Time-in],"hh:mm")

NeoPa

Quote:

Originally Posted by Renee Zarazinski

I have two fields Time-in & Time-out that are in military time. I have to calculate the difference (to get the total amt. of time spent working) then show the time as clock time. I've only been working with Access for 2 weeks and am not at the level yet to do this.

Are the military time fields stored as strings? Or are they Date/Time fields merely displayed in that format?

Time conversion from military to clock time

re: Time conversion from military to clock time

re: Time conversion from military to clock time

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about