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
  • 1 decade ago
    Best 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.