| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Sheet
Hi Guys!! Newbie Here! Please can youy try and help me out with a litle
problem regarding my Time Sheet? What I want is a formula (if possible (no pun intended)) to be able to ad up all my hours worked in total (cells d4 to d8.) This is simple to do I know using the SUM function, BUT, what I want to be able to do is if the total number of hours worked is zero then leave the total box blank (and not have a 0 in it.) Hope this makes sense!! Thank guys!! -- Yogi |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet
=IF(SUM(D4:D8)=0,"",SUM(D4:D8))
"Yogi_Bear_2k2" wrote: Hi Guys!! Newbie Here! Please can youy try and help me out with a litle problem regarding my Time Sheet? What I want is a formula (if possible (no pun intended)) to be able to ad up all my hours worked in total (cells d4 to d8.) This is simple to do I know using the SUM function, BUT, what I want to be able to do is if the total number of hours worked is zero then leave the total box blank (and not have a 0 in it.) Hope this makes sense!! Thank guys!! -- Yogi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet
Yogi
Or you could do your sum formula and goto Tools/Options/View/ uncheck zero values. This will cause all zeros to not be shown. HTH Mike Rogers "Teethless mama" wrote: =IF(SUM(D4:D8)=0,"",SUM(D4:D8)) "Yogi_Bear_2k2" wrote: Hi Guys!! Newbie Here! Please can youy try and help me out with a litle problem regarding my Time Sheet? What I want is a formula (if possible (no pun intended)) to be able to ad up all my hours worked in total (cells d4 to d8.) This is simple to do I know using the SUM function, BUT, what I want to be able to do is if the total number of hours worked is zero then leave the total box blank (and not have a 0 in it.) Hope this makes sense!! Thank guys!! -- Yogi |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet
Are you using hours in time format? If so you could just custom format the
sum cell as [h]:mm;; "Yogi_Bear_2k2" wrote: Hi Guys!! Newbie Here! Please can youy try and help me out with a litle problem regarding my Time Sheet? What I want is a formula (if possible (no pun intended)) to be able to ad up all my hours worked in total (cells d4 to d8.) This is simple to do I know using the SUM function, BUT, what I want to be able to do is if the total number of hours worked is zero then leave the total box blank (and not have a 0 in it.) Hope this makes sense!! Thank guys!! -- Yogi |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheet
Thank you very much!! Your great!!
-- Yogi "Teethless mama" wrote: =IF(SUM(D4:D8)=0,"",SUM(D4:D8)) "Yogi_Bear_2k2" wrote: Hi Guys!! Newbie Here! Please can youy try and help me out with a litle problem regarding my Time Sheet? What I want is a formula (if possible (no pun intended)) to be able to ad up all my hours worked in total (cells d4 to d8.) This is simple to do I know using the SUM function, BUT, what I want to be able to do is if the total number of hours worked is zero then leave the total box blank (and not have a 0 in it.) Hope this makes sense!! Thank guys!! -- Yogi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
| time sheet determination of what day and time rate | Excel Worksheet Functions | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| Excel formula for a time sheet | Excel Worksheet Functions | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Linear Mode
