how do I make 6:30am to 2:30pm appear as a number

January 17, 2012 at 12:18:48
Specs: Windows 7
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

See More: how do I make 6:30am to 2:30pm appear as a number

Report •


#1
January 17, 2012 at 12:30:05

Report •

#2
January 17, 2012 at 12:48:10
the actual number of hours between the 2 times .. in this case 8

Report •

#3
January 17, 2012 at 13:16:25
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.


Report •

Related Solutions


Ask Question