#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default if question

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default if question

Try this formula in column D
=IF(B1A1,"LATE "&TEXT(SUM(B1-A1),"h:mm:ss"),"EARLY
"&TEXT(SUM(A1-B1),"h:mm:ss"))



"puiuluipui" wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default if question

hi
try this....
=IF(A2<B2,"Late " &TEXT(B2-A2,"hh:mm:ss"),"Early "&TEXT(A2-B2,"hh:mm:ss"))

regards
FSt1

"puiuluipui" wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default if question

One mo

=IF(A2<B2,"Late ","Early ")&TEXT(ABS(A2-B2),"hh:mm:ss")



puiuluipui wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default if question

Thanks alot.

"Gary Mc" wrote:

Try this formula in column D
=IF(B1A1,"LATE "&TEXT(SUM(B1-A1),"h:mm:ss"),"EARLY
"&TEXT(SUM(A1-B1),"h:mm:ss"))



"puiuluipui" wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default if question

Thanks alot.

"FSt1" wrote:

hi
try this....
=IF(A2<B2,"Late " &TEXT(B2-A2,"hh:mm:ss"),"Early "&TEXT(A2-B2,"hh:mm:ss"))

regards
FSt1

"puiuluipui" wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default if question

Thanks alot.

"Dave Peterson" wrote:

One mo

=IF(A2<B2,"Late ","Early ")&TEXT(ABS(A2-B2),"hh:mm:ss")



puiuluipui wrote:

Hi, i have something like this

A B D
8:00:00 8:05:14 LATE 00:05:14
8:00:00 7:53:00 EARLY 00:07:00

I need the same formula to work for late and for early.
If i write something smaller than 8:00:00 to show early and the difference.
If i write something bigger than 8:00:00 to show late, and the diferences.
How can i do this?
Thaks in advance


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
where can I see my question and answer? Yesterday I ask a question IP Excel Discussion (Misc queries) 2 May 10th 08 04:08 PM
question A.S. Excel Discussion (Misc queries) 4 August 4th 06 08:05 AM
Question odditie New Users to Excel 6 August 4th 06 06:55 AM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
The question is an excel question that I need to figure out howto do in excel. Terry Excel Worksheet Functions 3 January 23rd 06 07:22 PM


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"