Separating Date/time field

  • Thread starter Thread starter uctopuk
  • Start date Start date
U

uctopuk

I am trying to separate a date/time field that appears as follows:
5/9/03 19:48

I need to retain all information, but in two fields so I can count the
minutes a program was accessed by date.

Thanks,
Uctopuk
 
to get the date only

=INT(A1)

format as date only or the time will still be there albeit 00:00

for the time only

=MOD(A1,1)

format as time only or you'll get 1/0/1900 as date as well
 
Back
Top