OOOH!

now I see

you are talking about the workbook_open code, while I'm talking about the table + formula I sent

WAIT A MOMENT

let's be clear ...

your question has 2 parts

**1. formula part**
your words:

Paste it in Excel and you ll be able to find out.

paste my table in your sheet and the formula in A4

I hope you read my explanation of the formula

**2. code when workbook opens**
paste only the code

Code:

```
Private Sub Workbook_Open()
MsgBox "hello," & vbLf & "the time is: " & Time
End Sub
```

when the workbook opens you should get a messagebox

when you can make both parts to work, when can focus on applying all this to your project

(so it's important you forget your project for a while to make the basics work: then we can elaborate)

best regards,

Erik