An Excel (Mac version) spreadsheet with a 'Allocated Time' Field in the format 0d 13h 2m needs to be converted to minutes. I would greatly appreciate any help.
Thanks in advance.
An Excel (Mac version) spreadsheet with a 'Allocated Time' Field in the format 0d 13h 2m needs to be converted to minutes. I would greatly appreciate any help.
Thanks in advance.
If you're happy to use formulae to do this, perhaps:
Formula:Please Login or Register to view this content.
Thank you for getting back.
It keeps coming up with an error. Not sure why. Help needed.
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)
- Click Advanced next to Quick Post button at the bottom right of the editor box.
- Scroll down until you see "Manage Attachments",
- Click the "Choose" button at the upper left (upload from your computer).
- Select your file, click "open", click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Close the Attachment Manager window.
- Click "Submit Reply"
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks