Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Adding military time from multiple cells

I am working on a spreadsheet to track total times that our local fire station is out on a call. I have to multiply the number of responders to the time to get an overall manhour time for the run. Once it goes over 24 hours it gives me a number other than what it should be. I then have to add all the times up for each run and I get the same problem after 24 hours. An example would be "T5" has the number of responders that needs to be multiplied into "V47" which is the run time. I have 5 responders with a run time of 5 hrs and 50 min. and it gives me a answer of 5 hrs and 10 min. Not sure what to do, please help.
Reply
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 a colon to military time Suzanne Excel Worksheet Functions 7 February 7th 13 10:51 AM
Excel 2007- Adding data in multiple cells at the same time G Excel Discussion (Misc queries) 1 April 22nd 09 12:25 AM
Show timesheet time in and out in regular time versus military tim John Excel Worksheet Functions 1 November 11th 05 05:14 AM
Adding time to multiple cells using TIMECODE timroutledge Excel Discussion (Misc queries) 1 May 25th 05 06:24 PM
adding military time format am6160 Excel Discussion (Misc queries) 2 December 28th 04 08:41 PM


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