Hi,

I am having some major issues, i created teh formula to state the
different in hours and minutes between 2 times. However, What i have
done is created the right vlookup formula to display a word instead of
a minute value. but the vlookup formula does not read the formula as a
proper value,

I have tried sum,value,=and text to display the minutes difference for
the vlookup formula to work but nothing works other than manual entry
please help as there are thousands for rows and will take all night by
hand.

:(


--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466408

look at DateDiff() to determine the diffrence between to times


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=466408

Thanks,

I have tried the date diff () suggestion and I am working with hours
and mnutes, so unfortunatly it doesnt work.

Cheers


--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466408

shoul not matter you can give it to date/times and the unit you want the
difrence in like "h" or "u" for minutes


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=466408