mark

Hi everyone, I track employee time as a cumulative number, so at the end of the week, they could end up with 40.25 hours for 40 hours and 25 minutes. Is there a formula to get this to convert the .25 to minutes without messing up the 40? Thanks in advance! Mark

Hi everyone its been awhile since i have been on here to post a question. so appologise now for this question. How do i mark my post as solved? i can not seam to find it anywhere. Thanks in advance

Hello everybody, I am new to this forum. My problem is following. In column "A" I have country codes In column "B" I have positive or negative value. Example -24.56 or 23 What I need is a formula that check if column A is "US" and value in column "B" is between -25 and 25 mark it as "Delete"...

Hello, I had created an report to follow up my orders, this report take the data from database, i would like to mark the new orders witch added after last update by "New*" for example. my data looks like: <tbody> <tbody> Order ID </tbody> <tbody> Order Date/Time </tbody> <tbody>...

hello I'm trying to add cells in a row which have been previously formatted by colour when they contain a tick mark. I can add the cells by colour when they have not been formatted but I have cells which need to contain a check mark with no highlight and cells which contain a check mark with...

Hi to everyone, i would be greatly appreciate if you could help so that to create a vba code and mark the usage range in excel. Please note that the rows are change each time whenever i download the data. Below is an example in col. "A", "B", "C" till row "8". Many thanks in advance A...

Hi All, New to the forum but have had loads of help from reading all the articles in the past. I have a tricky task which I am trying to achieve with excel and not sure if it is possible. I have a table that is laid out like below (with a couple rows completed). I want to be able to...

Hi I have a spreadsheet with 2 worksheets. Sheet1 holds a list of Names I.e. Mark, Paul, Peter etc Sheet2 holds daily data, Column A = 1st day, Column B = 2nd day etc (this information changes month on month when new data is pasted in), it holds the name of the person and then below it holds a...

Under CT1, use an appropriate function to find the highest class test mark for each student, using the class test percentages on the PROGRESS MARK worksheet. there are three sheets here first one being PROGRESS MARKS/ATTENDANCE RECORDS and last one MARK CALCULATIONS. Stud num Last Name First...

hi all.... i need formula in Conditional Formatting to fill data form with criteria : If in cell contains-filled green color put/insert mark checklist "X" for detail form, i attachment that file... https://app.box.com/s/gta2hsathmm73sb6z9pytq2nru9nu5ch any help much appreciated.. m.susanto

Hello everyone, I'm in desperate need some some VBA help! I have a number of identical files saved in a folder which I basically need to combine into one report. The format of each file is as follows - <tbody> A B C D E F G H 1 Employee Name 2 Employee Grade...

Hello friends, Hope all is well! please help me add an Exclamation/question mark (image) to the below msgbox. MsgBox "The Cost Details" & vbCrLf & "And/Or" & vbCrLf & "The Revenues Details" _ & vbCrLf & "Don't Exist", , "The entered Dr. ID is NOT showing" Thanks a lot in advance!

Hi! I have a sheet filled with 9-digit figures (ex. 172234512) There is a need to sort out every figure with the status of the 5:th digit. What is the most easy way to solve that? For example: if the 5:th digit is 3 (like above) then mark the cell red. If the 5:th digit is 2 (172224512) mark it...

hi all... i have table layout ... how to replace/remove after mark parenthesis (....) Excel 2007 32 bit DE 4dataafter formula 5text (aaaa aaa bbbbb)text 6text (aaa bbb cccccccccc)text 7text (aa ddd eeeeeeeeeeeeee)text Sheet: Sheet1 any assistance...much appreciated.. m.susanto

Hi Guys Have tried a variety of ways to complete this (simple!) task, but no joy so far. Thought I would ask other, more experienced people, if they could help out. I need a message box for column K and also may need to link in a formula to insert a check mark in the same cell in column L...

Hello, I am wondering if anyone can help. I am looking for a way to control which tabs are able to be unhidden based on a list. So basically, something very similar to a list box, but not a list box.. Let me explain I have tried using a list box, but it just doesn't seem sustainable. While...

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

I'm trying to write a macro that will do the following. Take a list of names and data and assign them to other people broken by header. For example from the following list: Christine gets all the data associated with Mark and Matt. Dolores gets all the data associated with Barb and Mike. Janet...

HI, I would like to have a marco that - after selecting a range (as usual via leftclicking and dragging) - marks all duplicates for each row individually (only the duplicates in each row are interesting) by filling the cell with a color. It seems, I can't attach files, sorry TIA!