# Convert Hours, Minues and Seconds To Time Decimal

1. ## Convert Hours, Minues and Seconds To Time Decimal

Hi,
I was wondering how i can amend this function
``Please Login or Register  to view this content.``
to change the time format to decimal. It is even better if I can just retain this function but able to find the difference between the start and end date and get the duration in units of hours and also in units of minutes.

There's a sample folder attachmed to this post. Thanks.

2. ## Re: Convert Hours, Minues and Seconds To Time Decimal

Not really clear what you want... are you by any chance saying:

Q2: =24*(P2-O2)

R2: =Q2*60

(test first to see)

3. ## Re: Convert Hours, Minues and Seconds To Time Decimal

Sorry if i wasn't very clear with the ques. I want to change the format 'time difference' eg in column N2, 2(hrs)45(mins):10(seconds) into hours, 4 decimal place and into minutes, 2 decimal place. You can ignore columns O and P. But i will need to amend the function in the the new start time and new end time first to find the time difference in hours. Likewise, to find the difference in minutes.

4. ## Re: Convert Hours, Minues and Seconds To Time Decimal

Now I really don't understand... post a revised sample manually inserting your expected/desired output in N.

5. ## Re: Convert Hours, Minues and Seconds To Time Decimal

A more simpler approach would be:

Q2: =N2*24
R2: =Q2*60

Then you can use the 'Format Cell' selection from the right-click cell menu. Choose 'Custom' from the categories of the Number Tab then type 0.000 in the text box for the 4 digit decimal and so on...

6. ## Re: Convert Hours, Minues and Seconds To Time Decimal

technoecrunch, welcome to the board, however please note:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

7. ## Re: Convert Hours, Minues and Seconds To Time Decimal

Oh sorry about that sir, will do. I'll be sure to not miss 'em next time. My apologies

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1