Hey again I promise not to send any ore about this for today. However, and maybe you knew and I didn't, but I think I figured out how to put in the results. I used the usual way Macs behave and guessed. After copying the today formula, I added the shift key to command v. It said pasting results of formula.
Gigi On Mar 15, 2014, at 9:33 PM, Eugenia Firth <[email protected]> wrote: > Hey Nic and others > I just tried something, and lo, it did what I was hoping. I also, I hope, did > what Tim suggested. I made a discovery by trying something, > On Mar 15, 2014, at 7:50 AM, Eugenia Firth <[email protected]> wrote: > >> hi Nick >> Thanks, and if I end up having to do time sheets, I will let you know. That >> could happen because the lovely state of Washington wants me to do that for >> my employee. They told me away around it, and I hope it works. >> Regards, >> Gigi >> >> Sent from my iPhone >> >>> On Mar 15, 2014, at 7:10 AM, Nicholas Parsons >>> <[email protected]> wrote: >>> and I had not a clue whether it would work. > > I came home and found out, yes, my formula had changed the 12th of March to > today, even though I thought earlier it hadn't. So just now I typed in the > equals sign and the word today and a minus sign and 3. Sure enough, the > computer subtracted back three days ago from today. I hope I made it stay > stationary by copying and pasting the formula back into the cell. We will see > if it stays the 12th of March and the 13th tomorrow. If it doesn't, I guess > I'll just have to go back to my old way and type the things in. Oh, I have > another cell that copied in for today's date. We'll see if it stays. > > Gigi > >>> Hi Gigi, >>> >>> That's odd your today() function didn't leave a function in the cell. >>> Perhaps because of the cell formatting or something? The behaviour with the >>> now() function, leaving an actual function there, is more the norm as I >>> understand it. From my testing, the now() function will update itself, so >>> if you go back and look at it you should notice that the time outputted by >>> the now() function should have changed. As I understand it, that's the >>> point of those functions, so that they can update to dynamically output the >>> current date/time. >>> >>> I'm not doing anything too flash with the date/time stuff, just keeping a >>> timesheet for work. Every time I start a new task or work for a new client, >>> I need to enter the start time and end time, so it's much easier if I can >>> do it with one quick key press rather than typing formulas, copying and >>> pasting etcetera. Otherwise keeping the timesheet starts to become a bit of >>> a task in itself. >>> >>> Anyway, if you wanted help creating that service thing that I created, I'd >>> be happy to give you step by step instructions, or just email you the file >>> or something. It's really pretty simple, and I know you'd be more than >>> capable of it. >>> >>> Best, >>> Nic >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
