I am very very very beginner when it comes to excel. I am being asked to add the time in lets say A1 and show the results in A2.

Example:

A1: 8am-5pm A2: 9

i know it would be easier to put 8 in A1 5 in A2 and show the sum in A3 but they do not want it that way. I am wondering if there is a formula to have it automatically add the time from cell A1 and have the results in A2. Im not too good when it comes to excel so i do not know all the terminology or steps to get there so if there is a way, simple basic steps would be greatly appreciated (like excel for dummies simple). i know there are many other post about this i just can't seem to figure it out :/ Thank you so much in advance!