hokiewalrus
Registered User.
- Local time
- Today, 08:35
- Joined
- Jan 19, 2009
- Messages
- 50
I have a payroll system that is dealing with a lot of time intervals as opposed to an absolute time (ie; 8:30 is 8 hours and 30 minutes, not 8:30AM) and I need some advice.
I've searched this forum a lot and read this: http://www.mvps.org/access/datetime/date0009.htm
Which seems like it would work but doesn't seem very...elegant, for lack of a better word. Especially since I'm going to have a fair amount of intervals that are longer than 24 hours and would love for them to display as hhh:mm
How do most people handle time intervals? It seems clear that the date data type wasn't really designed with this in mind, so should I try to make it work or should I attempt to roll my own base 60 data type?
I've searched this forum a lot and read this: http://www.mvps.org/access/datetime/date0009.htm
Which seems like it would work but doesn't seem very...elegant, for lack of a better word. Especially since I'm going to have a fair amount of intervals that are longer than 24 hours and would love for them to display as hhh:mm
How do most people handle time intervals? It seems clear that the date data type wasn't really designed with this in mind, so should I try to make it work or should I attempt to roll my own base 60 data type?