MIke K

Posts: n/a

Need absolute time from yesterday

Oh wise ones,
I run a report in the morning which calls
cells from yesterday morning at 7:00AM until now- if now
is before 7:00AM. Or if now is past 7:00AM, from yesterday
at 7:00AM until today at 7:00AM. I can do NOW and NOW-1
but I can't figure out the 7:00AM absolute time. Help is
much appreciated.

Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
time sheet	Rusty Boy	Excel Worksheet Functions	2	December 2nd 04 03:49 PM
Round Time	cpme	Excel Worksheet Functions	2	November 18th 04 07:09 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM

All times are GMT +1. The time now is 10:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us