Hi,

Rather new to using excel and I have been trying to get excel to calculate elapsed time between two dates using mostly what I've read from other elapsed time posts. But I am clearly missing a step. I'm trying to streamline my process for taxes. Appreciate any help.

I want to take a time in the format of " yy/mm/dd hhmm " example: 13/04/24 2245 ( note its a 24hr clock)
13/04/24 2245 would represent 2013 April the 24th at 10:45PM.


------- A --------------- B -------------------- C
13/04/24 2245 ------13/05/24 0900 ---------[display hrs elapsed] <-- currently get #name?


I have custom formatted A and B to yy/mm/dd hhmm and formatted c to [h]:mm
When you enter b-a in column c you get #name?

If its easier to have the date and time into separate columns I can give that a shot, I was just trying to make it as streamlined as possible for copy past.
Either way it will be quicker and easier than performing hundreds manually.