Biff

Posts: n/a

Hi!

Use a format like [h]:mm:ss

Biff

"Mike" wrote in message
...
Thank you so much! Also, what do I need to do to show Hr:Min and seconds

"Biff" wrote:

Hi!

Divide by 24 and format the cell as [h]:mm

=A1/24 = 17:30

Biff

"Mike" wrote in message
...
I have a program that gives me time in whole number format. ie 17.5
hours.
I
need to know how to I create a formula that would turn that in actual
hours
and minutes.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Formula for averaging times	Denise	Excel Discussion (Misc queries)	1	January 28th 05 04:05 PM
Formula for time?	shaggy78	Excel Discussion (Misc queries)	11	December 31st 04 08:13 PM
What is the formula for getting time difference e.g. ("4 hrs 15 m.	Sandeep Manjrekar	Charts and Charting in Excel	3	December 4th 04 05:18 AM

All times are GMT +1. The time now is 04:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us