View Single Post
  #3   Report Post  
Shirley Zaknich
 
Posts: n/a
Default

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