I need the date i have set up in a cell to be today -14 hours

[superchew]

I have a worksheet that i have for each shift as a passdownd and i need the date on that sheed to be today minus 14 hours so when night shift leaves there passdown the date reflects the shift they started on.

[Pete_UK]

Try this:

=NOW() - 14/24

Hope this helps.

Pete

[newdoverman]

With the date in A1 (date format recognized by Excel) and 14:00 entered in B1 (formatted as [h]:mm) in C1 enter A1-B1. The result will be a date and time. (formatted dd/mm/yyyy h:mm AM/PM)

Enter today's date using Ctrl+;

If you use today() or now() the value given is volatile and will change automatically. If that is the operation that you want enter the function that suits you in A1 instead of entering the static date.

It all depends upon what you need.