Sunday, August 8, 2010

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



Microsoft Access time formulas?pop up blocker



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.

No comments:

Post a Comment