Time [type mismatch]

Trying to subtract the end time from the start time and display it in an empty cell that I provided early on. I would like the number displayed in number of hours IE 1.5 Hours. but if not possible I can manage with 1:30 hours.

With the code below I get
rune time error 13
type mismatch

Please Login or Register  to view this content.

Any help would be appreciated

Here is a copy of my workbook.

Is there a way to make the txt format time. that seems to be the issue. but I cant seem to format the cells

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Still cant find a format that will work. Any sugestions?

With the cells them self:
1. are formatted to time hh:MM;@
2. inputs in column 1,2 are entered in time format
then in cell 3 (formatted as time of course) can =cell 1- cell 2
and it will give in time how many hours .

So now i need to copy the value from one sheet to another.
Sheet 1 called display (where the data is going)
and sheet 2 called DataBase

Thanks for the work that you did. I looked threw it and it is fantastic. Although I have found another way of doing what I want. although I think I can use your changes on other projects. Thanks again so much


~*****~

You are welcome,

Thank you for the Rep.