Easily Export Formula Document online
Did you know?
The tricky part is, the client would like the actual excel field to contain the formula (above) so that they can change the value in any of the Hourly Rate, Multiplier or Hours worked fields and this value will be re-calculated i.e. Hourly Rate exported is 16.00, if they change the hourly rate value to 17.50 u2013 they would like the Total Cost field to re-calculate based on the hourly rate now being 17.50 instead of 16.00
If you use the .csv file format for an export and then open the exported file in Excel, time periods may be automatically converted into dates. You can avoid this by using Excel's file import wizard: Export Time Periods to csv and Import into Excel