Convert minutes to date

[#1]

Hello all,

I have a field containing number of minutes strarting from a date. I want to have this field as a timestamp.

Field           Timestamp

727519        01/05/2015 05:19

Thank you if u have any clue

[sunny_talwar]

What is the starting date in your case?

[#3]

I only know that 727519  corresponde to this date  01/05/2015 05:19.
I can say that  in field2=field1-727519  the start date is 01/05/2015 05:19.

[sunny_talwar]

Assuming your date to be in this format: DD/MM/YYYY, the starting date seems to be 12/12/2013. Try this in a text box if its true:

=Timestamp#(Date(Date#('12/12/2013', 'DD/MM/YYYY') + Floor(Interval#('727519', 'mm')), 'DD/MM/YYYY') & ' ' & Interval(Frac(Interval#('727519', 'mm')), 'hh:mm'), 'DD/MM/YYYY hh:mm')

HTH

Best,

Sunny

[m_woolf · Accepted solution]

I gather that your start date is 8/18/2013

StartDate + Field/60/24 as TimeStamp

[sunny_talwar]

Awesome

I made a simple thing so much more complicated with my solution. I was just checking how your solution works and I guess to get him what he is looking for (in the format he is looking for), I added the TimeStamp() function around it:

=Timestamp(Date#('8/18/2013', 'MM/DD/YYYY') + 727519/(60*24), 'MM/DD/YYYY hh:mm')

[#7]

thank you for the answer

[#8]

thank you a lot !

[sunny_talwar]

I am glad we were able to help, but I think the answer came from mike woolf‌, you should reward him for the correct answer (and reward me with a helpful answer if you like )

[#10]

You are right, thank you both and all the community members who share knowledge