I have strings with hours and mins i.e "1 hour" or "7 hours 30 mins" or "10 mins". how to convert it to timestamp hh:mm so i can caclulate the totals? thanks
Novice
Windows 7 64bit 
Access 2010 64bit
I have strings with hours and mins i.e "1 hour" or "7 hours 30 mins" or "10 mins". how to convert it to timestamp hh:mm so i can caclulate the totals? thanks
VIP
Windows 7 64bit Access 2010 32bit
Use string manipulation functions. If your data varies that much, think will need a custom VBA function and it won't be simple.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote