Hey Steve,
Does one of these help?
=INT((B1-A1)*24)Total hours between two times (4)
=(B1-A1)*1440 Total minutes between two times (295)
=(B1-A1)*86400 Total seconds between two times (17700)
=HOUR(B1-A1)The difference in the hours unit between two times. This
value cannot exceed 2
Dear Rahul
Your suggestion is appreciable,But how can 1 know that other person
is new and he/she wants fundamentals first.
I think new member should ask for fundamental study material with
introducing himself.
On Mon, Apr 19, 2010 at 11:11 AM, lal rahul wrote:
>>
>>> Hi Group,
>>> To
>
>
> Hi Group,
>>
>> To begin with i m the newest member of this Group and would like to
>> APPRECIATE the efforts of the owners of this Group.
>>
>> SUGGESTION - Would it not be good to start a Tutorial step by step which
>> any one can join
>>
>> like i m in intermediate in excel would like to
If you know the time difference, following formula would
work ( for example in India, i.e. + 5:30 GMT) :
A1= IF(B1<"5:30",B1+"18:30",B1-"5:30")
Where A1 is the time difference between "input time (B1)" and fix time
("5:30").
The cells are formatted as hh:mm and time in "B1" will have to be enter
Hi Group,
To begin with i m the newest member of this Group and would like to
APPRECIATE the efforts of the owners of this Group.
SUGGESTION - Would it not be good to start a Tutorial step by step which any
one can join
like i m in intermediate in excel would like to know more about pivot
table
:13 -0700
> Subject: $$Excel-Macros$$ subtracting time
> From: mck1...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hello,
>
> I need to subtract a specific time in one cell from another time
> another cell to produce the difference of the two times. I also need
&g
Hello,
I need to subtract a specific time in one cell from another time
another cell to produce the difference of the two times. I also need
to consider passing through midnight, i may have a time on one day and
have to subtract it from a time on the next day.
Thanks in advance,
Steve
--
--