Microsoft Access time formulas?
Please, can anyone give me a formula that will calculate times in Microsoft Access?
I need a formula that will add Start time + End time that will give me a total for the day
Example: 8:30 am + 3:55 pm = total hours
- jesteele1948Lv 51 decade agoBest Answer
It's EXACTLY the same as if someone asked you how many hours are there between 8:30am and 3:55pm USING A 24 HOUR CLOCK! Do you know what each time is in 24 hour notation?
total hours = end time - start time.
if the cell for total hours is formatted as hh:mm:ss, you'll see the difference in hours, minutes, and seconds.
if the cell for total horus is formatted as Number, you;ll see either hours and decimal parts of an hour or the decimal part of a day (I forget which, but you can choose the Cell Format).
boy that was hard.