Hello,
I have need of some help. Thank you to anyone who replies or takes the time to read this. I am new in my Administration position and the biggest time suck is literally addition. I am not a lazy person however, I would like more time to make changes to the processes the previous admins in my position did not change for efficiency purposes.
I would like to enter time into my excel database in basic number form using a 24 hour format into two cells. One for beginning and one for ending. I have been trying for a few hours to fix the end result. I cannot get excel to calculate the elapsed time if it exceeds a 24 hour period, or from evening to morning.
for example: 1400 = A1, 0700 = A2. I would like A3 to calculate elapsed hours.
If I need to put in the date, I can do this. Is there a way to enter the date in number format without the hashes, and excel read the date and time so it can calculate the elapsed time in hours?
Thank you for your time and assistance.
Bookmarks