Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF forumla for time
I have a time and date field such as "5/25/05 13:05." I need a calculation
so that if the time is greater than or equal to 7:00, then it should return the same date. If it is after 7:00, it should return the next day's date. Thanks - Leigh Ann |
#2
|
|||
|
|||
=if(A1-INT(A1)=(1/24*7),a1+1,a1)
and format it as date "Leigh Ann" wrote in message ... I have a time and date field such as "5/25/05 13:05." I need a calculation so that if the time is greater than or equal to 7:00, then it should return the same date. If it is after 7:00, it should return the next day's date. Thanks - Leigh Ann |
#3
|
|||
|
|||
This will have today's date if it is before 7:00 AM (change the 7 to 19 if you want 7:00 PM) and tomorrow's date if it is after 7:00 AM =TODAY()+(NOW()7/24)*1 This will have the date & time =NOW()+(NOW()7/24)*1 "Leigh Ann" wrote in message ... I have a time and date field such as "5/25/05 13:05." I need a calculation so that if the time is greater than or equal to 7:00, then it should return the same date. If it is after 7:00, it should return the next day's date. Thanks - Leigh Ann |
#4
|
|||
|
|||
Thanks! Just the solution I was looking for! Leigh Ann
"N Harkawat" wrote: =if(A1-INT(A1)=(1/24*7),a1+1,a1) and format it as date "Leigh Ann" wrote in message ... I have a time and date field such as "5/25/05 13:05." I need a calculation so that if the time is greater than or equal to 7:00, then it should return the same date. If it is after 7:00, it should return the next day's date. Thanks - Leigh Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update forumla in same cell on each sheet | Excel Discussion (Misc queries) | |||
Forumla calculation | Excel Discussion (Misc queries) | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
Forumla to calculate a percentage | Excel Discussion (Misc queries) | |||
Excat Forumla HELP | Excel Worksheet Functions |