LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Adding hours and minutes

I am trying to add hours an dminutes within a cell. The only help hints I
can find tell you how to add hours & minutes when referencing an outside
cell. My problem is within one cell I need to find a formula to add 7 hours
35 minutes plus 20 hours and 58 minutes. I can a whole bunch of crazy
numbers - but I can never get it to be the 28 hours and 33 minutes it should
be.
I have a spreadsheet where I will have to continully be adding in additional
hours into each cell and I don't want to have to manually add them if Excel
can do it for me.
Can anyone help???
 
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
Adding up hours and minutes Dave Excel Discussion (Misc queries) 19 May 6th 10 06:06 PM
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 PM
Adding hours and minutes doyouknow2005 Excel Discussion (Misc queries) 2 July 10th 05 10:08 PM
Adding hours and minutes.. Ron Rosenfeld Excel Discussion (Misc queries) 2 June 11th 05 04:59 AM
adding hours and minutes Tricia New Users to Excel 2 November 27th 04 12:29 AM


All times are GMT +1. The time now is 08:21 PM.

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

About Us

"It's about Microsoft Excel"