I am trying to set up an invoicing system. I charge my clients by hours:minutes:seconds and need to convert the time to decimal. I have tried the convert to time function but this appears to apply to a time of day, not a length of time.
Can anyone suggest a formula to convert the length of time worked to a decimal figure which I can then multiply by the rate?
Many thanks
Mary Anne
Last edited by ExpressTyping; 01-24-2011 at 10:48 AM. Reason: solved
Assuming you want decimal hours multiply time value by 24 and format as Number / Decimal.
In XL 1 = 24 hours.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I found a similar thread by Google seach 'convert time to decimal Excel'. Maybe one of the last formulas suggested here can help you?
http://www.mrexcel.com/archive/Dates/632.html
Originally Posted by ExpressTyping
Thanks for the pointers. Have solved the problem by formatting the cell as general then converting to minutes and seconds and multiplying by 24.
Thanks for your help.
I'd say:
PHP Code:=A1*1440*'rate per second'
I'd say this is wrong, no?
As 24hrs * 60min * 60secs = 86,400seconds
1,440 is on minutes ( = 24hrs * 60min)
vayneart, welcome to the forum
THis thread is almost 3 years old, I doubt the OP is still following it (dont feel bad, I have done the same thing myself before lol)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks