LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 114
Default I am trying to calulate total time

I am working on a spreadshett to calulate my total hours worked. How can I
add this together? I have tried to just add the time with the SUM feature, I
have tried to add each item individually...However, the program is adding
these like they are actually times during the day and not total hours worked
each day. I am trying to find the total hours worked in the HH:MM format...I
should get a total somewhere around 30:52 but I am getting 6:57 as an answer.
How do I fix this?
 
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
Calculating total time David Gartrell Excel Worksheet Functions 2 June 23rd 06 08:39 AM
Need a formula to add the total # each time it finds a name Weasel Excel Discussion (Misc queries) 4 April 11th 06 05:06 PM
Calculating Business Hours Between 2 Dates tanya216 Excel Discussion (Misc queries) 3 April 11th 06 03:22 PM
template or formula for start time -finish time -total hours ple cc New Users to Excel 1 March 27th 06 06:06 PM
Total TIme worked jlogan21 Excel Worksheet Functions 2 January 4th 06 07:02 PM


All times are GMT +1. The time now is 09:06 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"