hai guys,
i am also here with the similar problem.
here is the situation.
there are 4 list's for start time & end time
A B C D E
1 st time | end time| hours
2 HH MM | HH MM |
3 -------------------------
4 5 00 6 30 1:30 ( what i am doing here to get the value for this cel
is E4=TEXT(TIME(a4,b4,0)-TIME(C4,D4,0),"hh:mm")
and this cell is in time format like "13:30"
Now i don't want this to be like 1.30, instead i want like in 1.50Hrs
for calculation based on hours comsumed).

And, i am using this E4 cell in VBA.
there are similar rows like 4. and i want to add the Hours(E) column
i.e
if E4 =1.50, E5=2.75 then i need to get 4.25.
how to do this in VBA.
plz help me
Thanks & regards,
Mahes

--
itsmahesh
-----------------------------------------------------------------------
itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=27689