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
Hi
try =TEXT(A2,h) in cell c2 drag down...
Cheers!!
ᐧ
On Sun, Jan 11, 2015 at 11:52 AM, Rakesh rksharma...@gmail.com 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
It's awesome.
-- Forwarded message --
From: Anonymous singhoram...@gmail.com
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
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,