How do I calculate hours in Excel
You should be able to just use a simple subtraction
for example, A1=9 am A2=12 pm A3=A2-A1 gives the result in A3 as 3:00 AM
you can then format A3 as custom and put h. This should give you 3
"Dragonrana" wrote:
I have a start date and an end date.What I need is to give the difference in
hours? How do I do that?
i.e. 9:00AM (Start Date)
12:00 PM (End Date)
Result : 3 hours
Thanks.
|