LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kevin
 
Posts: n/a
Default Multiple functions in one cell

I am trying to build a spreadsheet so I can track my times at work. I am
having trouble trying to create a formula for 1 cell that will sum all the
days of the month, and add a 1 for every 8 hours of standby time example:
01/02/05 4 hours of standby, 01/03/05 2 hours of standby, 01/04/05 8 hours of
standby, 01/05/05 2 hours of standby, with the total being 16 I want that
cell to calculate too 2.
Thanks for any help you can provide!!
Kevin.
 
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
Double-Clicking a cell for Multiple Options andym Excel Discussion (Misc queries) 1 February 24th 05 09:46 PM
How to make a cell recognize multiple text strings? Tourcat Excel Worksheet Functions 1 February 8th 05 08:29 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM
# of Functions per cell >> for Harlan Grove SUB-ZERO Excel Worksheet Functions 0 January 24th 05 02:39 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:19 AM.

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"