cgs60649

Lv 4

# 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

### 1 Answer

Relevance

- 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.

Still have questions? Get your answers by asking now.