The date in A1 will give you a serial number representing 00:00 ; i suggest you add half
a day (0,5) to that so you start counting at 12 noon.
Formula in A3 can be =((A1+0,5+A2/24)-Now())*24
The date in A1 will give you a serial number representing 00:00 ; i suggest you add half
a day (0,5) to that so you start counting at 12 noon.
Formula in A3 can be =((A1+0,5+A2/24)-Now())*24
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks