Many thanks Bruce. I did know, but couldn't get it to work, that you needed
to format back to time. But when I read your reply, I went in formatted the
start/finish time using the Custom settings of hh mm.
Thank you again - now I need to get the next part solved.
"swatsp0p" wrote:
I believe your answers (0.38 (start time) and 0.67 (finish time)) need
to be formatted as Time. In this format, 0.38 returns 9:07:12 AM and
0.67 returns 4:04:48 PM
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=396050