convert into date/time format

[okl]

Hi there,

I have 2 column data:
event_date_time
arrival-date_time

when i do a [arrival_date_time] - [event_date_time]
i got the output e.g as "42444.58", how can i convert to "dd/mm/yyyy hh:mm" format?

Thanks

 

[james_lankford]

you don't

because it makes no sense to do that

what if the difference is one day and 5 hours

do you expect to see
01/00/0000 05:00

that makes no sense at all

 

[okl]

you don't

because it makes no sense to do that

what if the difference is one day and 5 hours

do you expect to see
01/00/0000 05:00

that makes no sense at all

Hi,
i made a mistake.
What i trying to do is as in below:

[dd/mm/yyyy hh:mm] -[minutes]

example:
[19/03/2016 16:42:56] - [77.44] = 19/03/2016 hh:mm

to get the final result as dd/mm/yyyy hh:mm format

 

[thisoldman]

In Excel, hours, minutes, and seconds are represented as fractional parts of one day. One hour is one twenty-fourth part of a day or =1/24; one minute is =1/(24*60) or =1/1440; one second is =1/(24*60*60) or 1/86400.

If you have the number of minutes, your formula should be:
[19/03/2016 16:42:56] - [77.44 / 1440] = 19/03/2016 hh:mm