Hi There,
When i import a file the hours come through as 37.30 (which is 37 hrs and 30 mins) and in number format. How do i change this to show 37.5 in number format? I have a list of about 40 different entries and when i sum them up in Excel the total is always less than it should be because of this issue. Any help would be appreciated thanks
When i import a file the hours come through as 37.30 (which is 37 hrs and 30 mins) and in number format. How do i change this to show 37.5 in number format? I have a list of about 40 different entries and when i sum them up in Excel the total is always less than it should be because of this issue. Any help would be appreciated thanks