Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 90

Time factor

I'm sure I'm overlooking something simple...
Please help:

I'm adding time differences of:
0.02 (Minutes)
0.09
0.02
0.99
0.20

My total minutes equal:
132

I want to convert this number to the number of hours minutes which should be:
2:12

I can't seem to wrap my brain around this to find the answer.

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
Highest common factor	DavidObeid	Excel Discussion (Misc queries)	2	August 3rd 06 08:04 AM
Factor Analysis	Mary	Excel Worksheet Functions	1	July 26th 06 06:53 PM
IF FACTOR?	Bernadette	Excel Discussion (Misc queries)	2	June 8th 06 01:51 PM
Growth Factor	Laura	Excel Discussion (Misc queries)	2	May 15th 06 10:43 PM
PRIME FACTOR	Ted Moise	Excel Worksheet Functions	1	October 29th 04 06:40 AM

All times are GMT +1. The time now is 09:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us