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
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
Greetings,
I believe you have already started a thread with this question here:
mdmackillop
04-05-2010, 06:20 AM
Threads merged
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.