# Converting time.

1. ## Converting time.

I want to convert the time format. Don't know how to explain, will try to explain in the best possible manner.

Actual
1 hrs: 60 mins
If a programmer spend 1:45 min on work, his occupancy 1.75

Required.
1 hrs = 100 mins

what shud I do to get the same result.

2. ## Re: Converting time.

Try this

With Column A formatted "hh:mm" and Column B formatted "General" or "Number" Decimal places to suit (2)

In B2

=A2*24

Drag/Fill Down

Hope this helps

3. ## Re: Converting time.

Hi

Attach some sample file for more details.
I am not understand how 1:45 min on work, his occupancy 1.75.
Is 1.75 is amount or some thing else.

4. ## Re: Converting time.

Hi Marcol,

You are a genius, would love to have you as my mentor.

5. ## Re: Converting time.

Originally Posted by Marcol
Try this

With Column A formatted "hh:mm" and Column B formatted "General" or "Number" Decimal places to suit (2)

In B2

=A2*24

Drag/Fill Down

Hope this helps
Hi Marcol
The answer is right...can you please let me know the logic for the same.

6. ## Re: Converting time.

@ Rahul Nagar

I think the phrasing of the OPs' question is a little confusing. He means

1hr 45mins = 1.75hrs

Time and date values are based on units of one day therefore

1hr 45mins = 0.0729166666666667 days so multiply by 24 to get hours

7. ## Re: Converting time.

Originally Posted by Marcol
@ Rahul Nagar

I think the phrasing of the OPs' question is a little confusing. He means

1hr 45mins = 1.75hrs

Time and date values are based on units of one day therefore

1hr 45mins = 0.0729166666666667 days so multiply by 24 to get hours
Thanks for the clarification...

8. ## Re: Converting time.

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