jennyjsheffuk
Board Regular
- Joined
- Jun 14, 2007
- Messages
- 209
I would like to show ResultTime as 1:25:00 instead of 0.059027778 as currently displayed in the message box answer.
EmployeeTime = ActiveCell.Range("A1")
ResultTime = ActiveCell.Range("B1")
Answer = MsgBox("You searched for " & EmployeeTime & vbCr & _
"Their Total Time worked is: " & ResultTime, vbOKOnly, "Result!")
Can anyone help me please to set the & Format(ResultTime,[h]:mm:ss
EmployeeTime = ActiveCell.Range("A1")
ResultTime = ActiveCell.Range("B1")
Answer = MsgBox("You searched for " & EmployeeTime & vbCr & _
"Their Total Time worked is: " & ResultTime, vbOKOnly, "Result!")
Can anyone help me please to set the & Format(ResultTime,[h]:mm:ss