Date Format

[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

 

[Guest]

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

 

[Guest]

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

My apologies for the error.

Regards,

OssieMac

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

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