| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Q
How could I construct a formula that says:- IF the Time NOW is 18:00
but < 24:00, carry out formula A, if Not then carry out Formula B? What I can't get my head around is extracting the time element from the NOW() function (and not the date. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Q
Either of these will give you the current "Now" time...
=NOW()-TODAY() =MOD(NOW(),1) -- Rick (MVP - Excel) "Seanie" wrote in message ... How could I construct a formula that says:- IF the Time NOW is 18:00 but < 24:00, carry out formula A, if Not then carry out Formula B? What I can't get my head around is extracting the time element from the NOW() function (and not the date. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Q
Thanks Rick
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
