I’m trying to dump a text file from an Excel sheet with calculated results.
I need to do some time calculations and then take the results and export them to a text file.
Here is a simplified example of what I am trying to do …
A1 = start time
B1 = duration
C1= end Time (calculated)
D1 formula will read
=CONCATENATE (“Start time is “,A1,” for a duration of “,B1,” ending at “,C1)
I have formatted C1 to use time hh:mm
C1 displays exactly the way I want it to in the sheet but if I try to copy the result from C1, it will read in a decimal form. So instead of the result being:
Start time is 1:00 for a duration of 30 ending at 1:30
It reads
Start time is 1:30 for a duration of 30 ending at 0.56251530
Thank you
I need to do some time calculations and then take the results and export them to a text file.
Here is a simplified example of what I am trying to do …
A1 = start time
B1 = duration
C1= end Time (calculated)
D1 formula will read
=CONCATENATE (“Start time is “,A1,” for a duration of “,B1,” ending at “,C1)
I have formatted C1 to use time hh:mm
C1 displays exactly the way I want it to in the sheet but if I try to copy the result from C1, it will read in a decimal form. So instead of the result being:
Start time is 1:00 for a duration of 30 ending at 1:30
It reads
Start time is 1:30 for a duration of 30 ending at 0.56251530
Thank you