View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Learner Learner is offline
external usenet poster
 
Posts: 27
Default MsgBox to display [hh]:mm

Trying to finish up the macro with this message box

wtime=ActiveCell.Value
MsgBox("You worked for " & wtime & "Hrs:Min")

Cell where the value is taken from contains formula, is formatted as [hh]:mm
and is displayed right. But when I try to use the value in the message box, I
get something like 9.12435E-3.

It's gotta be simple but I can't figure it out.
Thank you