Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am using software, which export the report to csv format, in the date the
format is dd/mm/yy hh:mm:ss and when I try to convert the format to
[hh]:mm:ss then its comes like 942726:03:23, why?

Thanks & Regards

Hassan
 
Excel sees the date and time as number of days and fractions of days from 1st
jan 1900. If you want to extract the time only from the date then you need to
subtract the integer of the date/time from the actual date/time.

Example: Your date and time in cell A1 as 10/9/2007 17:00

in cell B1 you could enter =A2-INT(A2) and format the cell to [hh]:mm

Regards,

OssieMac
 
Example was incorrect for the value in Cell A1. Should have been:-
=A1-INT(A1)

My apologies for the error.

Regards,

OssieMac


OssieMac said:
Excel sees the date and time as number of days and fractions of days from 1st
jan 1900. If you want to extract the time only from the date then you need to
subtract the integer of the date/time from the actual date/time.

Example: Your date and time in cell A1 as 10/9/2007 17:00

in cell B1 you could enter =A2-INT(A2) and format the cell to [hh]:mm

Regards,

OssieMac



Hassan said:
Hi All,

I am using software, which export the report to csv format, in the date the
format is dd/mm/yy hh:mm:ss and when I try to convert the format to
[hh]:mm:ss then its comes like 942726:03:23, why?

Thanks & Regards

Hassan
Click to expand...
Click to expand...
 
Back
Top