# Posts by dodger7

• ## formula for converting minutes into 7 hour shifts

Re: formula for converting minutes into 7 hour shifts

your right h1h, error on my part. that solves my problem, thanks

• ## formula for converting minutes into 7 hour shifts

folks,

ive got a spreadsheet which people are completing on how many minutes they are working on a certain project. im needing a formula to convert the minutes into 7-hour shift equivallent. for example, if there is a total of 300 minutes im needing a formula to show "5" shifts. or if its 350 minutes, show 5.83 shifts

• ## formula for "if any cell in a given range is NOT blank then Y if all blank no"

folks,

trying to get a formula for the above, which is:

"if any cell in a given range is NOT blank then Y if all blank no"

thanks you!

also, ive got a spreadsheet which people wil be filling in. I need a formula to say "if B4 is "Y" then show text from B3 plus sum of B2.

for example: B4 is: will you be working overtime? Y or N
B3 what will you be working on?
B2 how many minutes will you be working on this?

• ## sheet saved as shared but opens as read only?

Re: sheet saved as shared but opens as read only?

seems to work now mate cheers for your help

• ## sheet saved as shared but opens as read only?

Re: sheet saved as shared but opens as read only?

yeah it comes up with who it is, but its not me. however, when I go into share workbook, it has me twice? that anything to do with it?

• ## sheet saved as shared but opens as read only?

Re: sheet saved as shared but opens as read only?

has not mate, checked that

• ## sheet saved as shared but opens as read only?

Hi,

Im in an office and have created a spreadsheet as shared but when someone is in it and I try and open it, it opens with the "read only, notify and cancel" options. If I open it as read only, then the header in excel window is [workbook name][read-only][shared] - which I didnt think was possible.

any ideas?

thanks

• ## custom type under format cells?

hi folks,

ive got a very simple formula =sum(B2:F2)
within B2:F2 there is a list of numbers (25, 19, 45, 68, 34)

i was wondering how I can have the total of B2:F2 formatted into hours and minutes - ie total is 191, how can i get this to show 3 hours 11 minutes? or 3.18h?

thanks very much

• ## comparing a cell to a date

hi folks,

I need a formula to say if a cell value is before the 01/06/03 then Y, but if after then N. any takers?

• ## sum box missing

Hi Guys,

see when u have a sheet of figures, and you highlight a few cells - there is usually a box at the bottom of the sheet which tells u the sum. This is missing. do you know how to get it back?

Thanks a bunch!

• ## columns showing numbers instead of letters - also formula required

Hi folks,

my spreadsheet is sowing numbers instead of letters in the column headers. anyone know how to change this back?

also need a formula for the following:

I have a figure in C5, and need D5 to show (C5 minus 2.5 percent)

cheers people

• ## Enable Macro

Re: Enable Macro

the macros is greyed out aswell, cant even get into that :?

• ## Enable Macro

H folks,

I bought a PC seocnd hand from my work as they got new ones and were selling off their current stock. However, the macro has been disabled as it was not needed at work and I do not know how to enable it (i.e when you go to tools, macro its greyed out and cannot selet it)

anyone know how to enable this again?

thanks

• ## command for colouring a cell when more or less than a certain value

Hi, does anyone know the command for changing a colour of a cell depending on the value of it? for example, it is currently =IF(SUM(B4:L4)>16,"+" & SUM(B4:L4)-16,IF(SUM(B4:L4)<16,"-"&16-SUM(B4:L4),""))

I want it so that if the value is >16 it fills green, or <16 it fills red

thanks very much

• ## Hide the Print Preview Lines

Re: Hide the Print Preview Lines

cheers dude

• ## Hide the Print Preview Lines

Hi,

Does anybody know how to remove the print preview lines from your sheet that shows you what will come off each page? It is really annoying me, and I know it will be something SO simple! Its always pops up when you have been into print preview

thanks

• ## countif formula

Re: countif formula

thats great mate,

thank you very much for taking the time do do that sheet for me and explain that.

• ## countif formula

Re: countif formula

yes thats cool mate, cheers

Can I ask what the \$ sign is used for? I can only do basic formulas, therefore this is new to me

cheers again

• ## countif formula

Hi folks,

I have a spreadsheet with a list of names repeated from A1 to A30 (i.e in cell A1 I have "system", cell A2 "network", cell A3 "system") etc. and in column B I have either "Y" or "N". I need a formula to count the amount of "Y"s and "N"s each has.

can anyone help?

if any further info is required, please give me a row for not being clear enough

cheers folks

• ## Formula for comparing totals?

Re: Formula for comparing totals?

thats perfectly what I need,
cheers mate