PDA

View Full Version : Plugging time in excel sheet



aligahk06
04-05-2010, 01:26 AM
Dear All,

I want to input in a cell 7:00 i.e the cell format in such a way that if input 7 it automaticall convert into 7:00.
Any help

Rgds,
Aligahk06

GTO
04-05-2010, 03:27 AM
This will not convert 7 to 7:00, however, it will convert 700 to 7:00 and may be suitable, or give you a start...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=75

aligahk06
04-05-2010, 04:10 AM
Dear All,

I want to input in col C following time format 7:00 and in col D 18:00. In col E Difference of time D and C.

There are two much values to plugging in corresponding C Col and D Col.

While plugging in cell if plug 7 then it appear as 7:00 ( i.e 7 pm ) and 18 then appear as 18:00 (i.e 18:00 PM).
Then i want to calculate the difference of time.

Is there any way that convert 7 to 7:00 and 18 to 18:00 respectively?

Please assist?

Rgds,
Aligahk06

GTO
04-05-2010, 04:15 AM
Greetings,

I believe you have already started a thread with this question here:

mdmackillop
04-05-2010, 06:20 AM
Threads merged