LinkBack URL
About LinkBacks
Hi I am looking for a way to subtract NOW() from a particular cell which has an example time of 17:23. how do i write the formula and account for midnight crossover.
Hi I am looking for a way to subtract NOW() from a particular cell which has an example time of 17:23. how do i write the formula and account for midnight crossover.
Why can't you use:Formula:
Please Login or Register to view this content.
As for midnight crossover - how will you know if 17:23 is today or the next/previous day?
Will the difference to be calculated always be less than 24 hours?
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
You could also test using the MOD function. A formula like thiswill always give the right time difference even if it passes midninght.
Please Login or Register to view this content.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks