Good job, Kevin. I actually miss read the instructions and put A1 in front
of A2 and it didn't work (######.) Then I switched the elements on my own
and it worked. I was already to "blame" you, but something told me to reread
your instructions. And of course you were exactly right.
I appreciate it.
--
Dewey
"Kevin Lehrbass" wrote:
Hi Dewey,
If 4:00 pm is in cell A1 and 5:15 pm is in cell A2, then in cell A3 put =A2-A1
Also, in cell A3, you must go to Format Cells, number tab, custom and enter
"[h]:mm".
If you have any questions, don't hesitate to send me an email.
Have a great weekend,
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com
"Dewey" wrote:
Is there a formula that can calculate the difference between two hour/minute
entries, such as converting the time between 4:00 and 5:15 is 1:25.
--
Dewey