Hi
try =TEXT(A2,"h") in cell c2 & drag down...
Cheers!!
ᐧ
On Sun, Jan 11, 2015 at 11:52 AM, Rakesh wrote:
> Dear experts
>
> kindly help me to change start time format .
>
> *StartTime* required format *10/26/14 3:08 AM* 3 *10/26/14 3:09 AM* 3
> *10/26/14
> 3:45 PM* 15 *10/26/14 3:45 PM
Dear experts
kindly help me to change start time format .
*StartTime* required format *10/26/14 3:08 AM* 3 *10/26/14 3:09
AM* 3 *10/26/14
3:45 PM* 15 *10/26/14 3:45 PM* 15 *10/26/14 3:46 PM* 15 *10/26/14 8:11
AM* 8 *10/26/14 4:23 AM* 4 *10/26/14 4:15 AM* 4 *10/26/14 6:16 PM*
18 *10/26
Respected Neeraj,
Excel stores all dates as integers and all times as decimal fractions. With
this system, Excel can add, subtract, or compare dates and times just like
any other numbers, and all dates are manipulated by using this system.Times
are stored as decimal numbers between .0 and .9,
It's awesome.
-- Forwarded message --
From: Anonymous
Date: Wed, Jul 17, 2013 at 5:57 PM
Subject: $$Excel-Macros$$ Re: Help Required
To: excel-macros@googlegroups.com
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for
HI All
Greeting you all mebers , I have a problems in formula function . I want use
=NOW() For India ,=NOW() for USA etc in sinle sread sheet how it will please
suggest me
Regards
Alok Dbs
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http
