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: 1
Default Excel Formula, text & number in cell

I need your help, thank you for taking the time! :o)
I am making a spreadsheet to calculate time away from work. I would like to
be able to enter 8 PTO (8 hours paid time off) and another cell calculates
how many times that was entered in a column and adds that for me
automatically. My spreadsheet has the calendar, so all a person needs to do
is input the hours and the type of time taken (we also have holiday time; HT)
and it will automatically add it up for them. Please help! Thanks again!
 
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
number and text in cell for formula paulg Excel Worksheet Functions 6 August 21st 08 04:41 PM
how do i get formula to recognise text as = to a number?(excel) david Excel Worksheet Functions 2 March 9th 07 05:55 PM
display text in one cell as a number in an adjacent cell in excel Denno New Users to Excel 1 November 16th 06 05:13 PM
extract number and use in formula from text & numbers in cell ivory_kitten Excel Worksheet Functions 3 July 14th 06 05:38 AM
cusip (number and text) in same cell- How do use in excel? John K Excel Worksheet Functions 4 March 19th 05 07:38 PM


All times are GMT +1. The time now is 02:43 AM.

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"