LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default summing up hours

How do I get the sum in hours and minutes for a range of fields that
are formatted as "time" (hh:mm)?

I have two columns, one with starting time, one with ending time and a
third column that calculates the difference between ending and
starting time.
I can sum up the third column, but only until it exceeds 24 hours.

I understand that hours are handled like fraction of a day and I guess
I have to convert that fraction into a number.

At the same time I would have to keep the minutes as a fraction of an
hour, because otherwise the summing up would be confused?

TIA
Örjan Skoglösa
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Summing hours and munites shahalam Excel Discussion (Misc queries) 2 January 27th 10 10:59 AM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 08:40 PM
summing up hours spent on jobs kayti57 Excel Discussion (Misc queries) 2 November 29th 06 05:51 AM
Summing hours Driver Excel Worksheet Functions 1 October 25th 05 10:55 PM
Summing Hours and Minutes KenRamoska Excel Discussion (Misc queries) 1 October 6th 05 10:26 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"