Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default excel time function

Hi,
I have a set of dates in one column and a set of different times in another.If the date is same , I need to check if there is a difference of 1 mi in the times. Can someone please help me.

Nitya
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 829
Default excel time function

"Nitya Satheesh" wrote:
I have a set of dates in one column and a set of different
times in another.If the date is same , I need to check if
there is a difference of 1 mi in the times.


A concrete example might help us understand your requirements more
specifically.

If A1:A100 contains dates and B1:B100 contains times, and if you want to
check only adjacent times and return TRUE (difference of 1 min) and FALSE
(difference of more or less than 1 min), try the following starting in C2
and copying down through C100:

=(A2+B2-(A1+B1)=TIME(0,1,0))

Note: The outer parentheses are not required. But they might make the
intent of the formula easier to understand.

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
Macro / function text time to 24hr excel time passed midnight fortotaling hr's Russmaz Excel Worksheet Functions 2 March 6th 09 05:58 AM
Excel Time Function Rich Excel Worksheet Functions 3 January 27th 09 06:20 PM
Will Excel's time function do this? Bob Newman Excel Worksheet Functions 1 January 31st 06 06:55 PM
TIME function used in Excel jeramy Excel Worksheet Functions 1 July 2nd 05 02:59 AM
Time function in Excel Ian M[_2_] Excel Programming 2 July 19th 04 12:39 PM


All times are GMT +1. The time now is 08:54 AM.

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"