Military time conversion
Trying to find a way to solve this: I am doing time and date tracking for a support app. I have a date field. I also have a start time and end time fields where I would like to user military t...
Forum Discussion
Hi Ed,
I'd recommend using Time of Day type fields for your Start/End fields. In the field properties you can set them to 24-hour clock for military time. You can then use a Formula - Duration field as your Tot field, and set the field property to HH:MM.
If you need to stick with numeric type fields for Start/End, you'd need to get a bit creative with your numeric Tot formula.
------------------------------
Nathan Underwood
------------------------------
I'd recommend using Time of Day type fields for your Start/End fields. In the field properties you can set them to 24-hour clock for military time. You can then use a Formula - Duration field as your Tot field, and set the field property to HH:MM.
If you need to stick with numeric type fields for Start/End, you'd need to get a bit creative with your numeric Tot formula.
------------------------------
Nathan Underwood
------------------------------
Hi Nathan,
That worked perfectly.
You're a genius. Nobody at QB would tackle it.
I owe you a beer! I live near Port Townsend.
------------------------------
ed cooper
------------------------------
That worked perfectly.
You're a genius. Nobody at QB would tackle it.
I owe you a beer! I live near Port Townsend.
------------------------------
ed cooper
------------------------------
