| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
Example was incorrect for the value in Cell A1. Should have been:-
=A1-INT(A1) My apologies for the error. Regards, OssieMac "OssieMac" wrote: 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" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Hybrid Mode
