I am trying to build a simple work schedule ... I want to type in scheduled hours in one cell and have the numerical value displayed in the cell below

What "numerical value" are you referring to?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

the actual number of hours between the 2 times .. in this case 8

I don't believe that you can simply put both times in one cell and then determine the elasped time. The times have to be placed in 2 separate cells because of the way that Excel stores Dates and Times internally. To help you undertstand how Excel deals with dates and times, read the information found via this link. Once you know the basics, the actual calculations and formuals used will make more sense.

http://www.ozgrid.com/Excel/ExcelDa...

After you review that page, try here:

http://www.ozgrid.com/Excel/date-ti...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll