Is there a way to get the current date and time from a website and display it in Excel?
Is there a way to get the current date and time from a website and display it in Excel?
is there any reason why? there is a perfectly good clock in the bottom right of your monitor"
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I'm trying to create a clock in/clock out spreadsheet for my employees and I want to use a clock which they can't manipulate.
you can add a ms outlook date control lets users select the date from a calender view
I'm guessing the OP has a network-served timesheet and wants to prevent employees from setting the time back on their PCs before they open it.
Entia non sunt multiplicanda sine necessitate
My company has several different work sites and the computers are not networked. I have created a workbook that works well as a clock in/out device. The only weakness is that it relies on the clock of individual computers which obviously can be changed prior to clocking in and out. If there is a way to direct Excel to use the date and time from a website then it's good to go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks