Posted to microsoft.public.excel.misc

claude jerry claude jerry is offline

external usenet poster

Posts: 70

Converting total summed into hh:mm

Hello all

I have a work sheet which shows minutes worked by an employee

A B C D E F G
30 30 0 30 30 60 180

Col A to F shows hours worked in minutes eg. 30 min 60 min etc
Col G =Sum(A2:F2) calculates total time worked for the week

I want Col G to show totals in Hours HH.MM eg 3Hrs

Thanks In advance

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
Converting Total Time hh.hh to HH:MM:SS	David A.	Excel Worksheet Functions	5	December 28th 07 05:04 PM
Converting total minutes into hours and minutes in Excel	colette	Excel Worksheet Functions	11	December 26th 07 07:24 PM
Add to Summed Figures	acopper57 via OfficeKB.com	Excel Worksheet Functions	0	May 17th 06 10:40 PM
Add to Summed Figures	acopper57 via OfficeKB.com	Excel Worksheet Functions	0	May 17th 06 10:39 PM
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	2	March 20th 06 02:29 AM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us