I need help reading time
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 |
All times are GMT +1. The time now is 06:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com