calculating hours into date format
I would like a formula that will allow a user to input a figure (hours and
minutes) into a cell that will calculate the end date and time based on a
start date and time. For example,
Enter 30 hours, static start time is 01/01/04 00:00hrs, the formula would
then calculate that the end figure is 02/01/04 06:00hrs. Essentially it is
calculating the number of hours & mins added onto the start date with the end
result a date and time later than the hours & mins entered
Hope this makes sense!
in A1 put your date
in B1 enter your hours in the format hh:mm
and forma...Date Navigator
I use Outlook 2002 ... this just started happening & I do not know what to
do to resolve. Any assistance would be appreciated.
In Date Navigator portion of Calendar, January 4, 2007 is bolded even though
I have no appointments on that day? How can I get this date unbolded?
...time calculations #6
Does anyone know how you can calculate worked hours in a day on the
basis of a start and end time?
"Aline" <A_Mangelschots@hotmail.com> wrote in message
> Does anyone know how you can calculate worked hours in a day on the
> basis of a start and end time?
With start time in column A, and end time in column B, enter in C1
will give the time interval, even allowing for time period where the start
is on...Calculating Tax on 100% Discount (POS V1.3.1006)
Please check this:
On the POS put the Discount (Shift-F3) to 100% for the whole transaction.
Enter an item that requests the Price entry at the POS.
Enter a price.
Watch the Tax at the bottom of the screen.
You get a receipt with a Total of 0,00 including a tax of
what the regular tax would be if the item wouldn't have a 100% discount.
Isn't that a bit weird?
try updating to 1.3.1011 and see if its fixed.
"Christian Olsen" <ChristianOlsen@discussions.microsoft.com> wrote in
&g...add a date without holidays
I have a problem, in a macro I need to calculate a date adding working days
This add not include saturday / sundays and holidays.
21/5 + 6 days = 31/5
How i can to do ?
Thanks in advance and sorry by my english,
For adding days, use the DateAdd function. It won't return an invalid date
The Weekday function returns the number of the day, for instance this
returns 6 for Saturday, tomorrow it will return 7 for Sunday.
For holidays I can't help...Lookup for oldest date among different dates
I badly need your help in the below formula
Structure : Account includes Sub-accounts and each sub-account includes dials
Formula : Account activation date = Oldest Sub-account activation date
where there is more than one account and hence different activation
date for each account and in turn the sub-accounts that belong to each account
Below the example
A B C D
Account # Sub-Account # Account Sub-account
...Insert date en time with onchange function
I have a ntext field in a service indenity . When it is edited i want
automaticly insert date en time.
Can anyone help?
In your onChange event for that field, you may add
var currentTime =3D new Date()
var month =3D currentTime.getMonth() + 1
var day =3D currentTime.getDate()
var year =3D currentTime.getFullYear()
crmForm.all.[Your Field].DataValue =3D month + "/" + day + "/" + year;
hope this helps.
Darren Liu, Microso...How to create a calendar from date information in XL sheet.
I have an XL spreadsheet that contains multiple columns,
one of which contains data in date & time format. Is
there a way to export this data and associated information
from the record to another application, for example Word,
and create a calendar? Any suggestions how to manipulate
this XL data are welcomed. Thanks!
...date is in 20010129 format, how can I get it in m/d/y format
Data>text to column, go to step three and select date and YMD
and for future posts it's considered rude just using the subject line
With the value 20010129 in cell A1, enter this formula in B1:
and the format the cell as a date. The various functions parse the
20010129 string into its components, and the DATEVALUE converts that
string to a datevalue that Excel can recognize.
Hi I use a paper form at work that asks 3 multiple choice questions. The
answer to each question is given a score, and the total score is then used
to calculate whether risk is low, medium, high or very high.
What I'd like to do is set this up in Excel 2002 so that the user simply
clicks to select their choice for each question, and the score then results
in the assessed risk level being printed on screen.
Can anyone please either give me an outline of how to do this, or point me
to where I can find a sample that I could modify.
My email address as shown in newsgroups is fictitious. B...Current Date 01-20-10
I would like to filter on todays date. What is the field name for the
current date. Thanks.
Try "Current Date."
- Andrew Lavinsky
> I would like to filter on todays date. What is the field name for the
> current date. Thanks.
...calculating Week numbers in a time table
I have a weekly timetable table for school terms with the following fields
WeekID (automatic number), WkbeginDate (date), WkNo ( number 1 or 2). The
WkNo can be either 1 or 2 . How can I get the Wkno field to automatically
update with the correct week number for each new record ie if a record has
week value 2 the next record will have a WkNo value of 1? I would prefer to
do this using a query rather than a form.
The timetable is not for the whole year and has 'holiday' breaks, sometimes
restarting on a week 2, sometimes on a week 1.
Hope this makes sense!
=?Utf-8?B?SGls...counting dates #2
in cells D & E i have a series of dates. I want to put a formular E - D =
calculated number of days and i also dont want it calculating weekend?
the purpose of this is excel to work out how many days it takes to serve a
is this possible and if so what is the formular please
Holidays would be a range containing the dates of public holidays you wish
to de excluded from your calculation.
for example in your case, if you entered the range of holiday dates in cells
"jenn...calculating time (for payroll)
I'm trying to use Excel like a "time clock" to check in/out of work. I
want to be able to write the time in a certain cell that I came into
work, left for lunch, came back from lunch, and left for the day. I
then want to add up the hours for the week and any hours up to 45 I
need to multiply by a dollar amount. Also, any hours above 45 I need
to calculate for overtime.
I can add the ours to get a total for the week but am having a hard
time with multiplying "Time" by a dollar ammount. (Nevermind that I
have to find the amount of hours overtime) Attached is a very s...Subtracting minutes from a date
Is there a way to subtract 15000 minutes from todays date and show the
results in date format.
A1 = todays date
c1= A1-b1 (the date that many minutes ago)
Format as Date
Microsoft MVP - Excel
"J. T. SYLVESTER SR." <firstname.lastname@example.org> wrote in message
> Is there a way to subtract 15000 minutes from todays date and show the
> results in date format.
> A1 = todays date
> b1= #minutes
> c1= A1-b1 (the date that many minutes ago)
Su...Multiple date validation in a single cell
I am trying to do a rather complicated validation (I think it i
I want to allow ONLY dates of a particular format to be entered int
the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY
For example, the same cell can have either one of these format
entered, but MUST match one of them to be accepted.
1970 is OK and is captured in the cell as 1970 (not 1/01/1970)
70 is assumed to mean 1970 on entry
05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970)
5/70 or May-70 is assumed to mean 05/0970 on entry
05/06/2004 is OK
5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...Hide Alternate Labels on Date Axis
I'm having trouble trying to hide every other label along a horizontal
date axis. I start on the 01-Jan up to 10-Jan and through using the
'Format Axis'->'Scale'->'Major Unit' and setting this to 2 I can hide
the labels: '02-Jan'; '04-Jan'; etc.
However, I want to hide the odd dates: '01-Jan'; '03-Jan'; etc. I have
tried the various combinations with the dialog box but can't get
anything to work.
Should I be using a custom formula or something?
Any help is much appreciated.
In article <1168177092.892944...between calculation?
Can anyone help me with a little problem? Im sure you can
I have a row of cells with percentages in so looks something like this
Any way what I want to acheive is in the colum next to this I woul
like a formula that would say if the value in the percentage colum wa
between 200%-175% then it would be 30p. Or if its between 174.99%-150
then it will be 25p. Working its way down to zero.
Can this be done in Excel? As I dont know where to start I have trie
a few formulas myself and got a response of complete mash :
Message posted from http://www...Another question regarding Dates..
First, thanks to the replies to my previous post.
How can I work out the day & month when I only know the Year and Day Number?
Year = 2004
day number = 302
The answer I'm looking for is 28/10/2004
Again, taking into consideration the leap years
Thanks again in advance
"Anthony Slater" wrote:
> First, thanks to the replies to my previous post.
> How can I work out the day & month when I only know the Year and Day Number?
> Year = 2004
> day number = 302
> The answer I'...Date an time on WinXP.
Does anyone know where windows Xp gets the time and date it displays from?
My system date and time often fails, resulting in the time beiing 5-5mn
delayed compared to what
it shoul have been . I wonder what can cause that????
...how do I stop Excel taking decimal fractions as dates?
sometimes when I enter decimal fractions Excel thinks this is a date. How do
I stop this?
Insert a single quote before the fraction '3/4
The quote will not show up in the cell, but it will tell Excel to treat
the cell as Text.
3/4 will display as 3/4 but will be stored as 0.75 and can be used in
"aa" <A@aa.com> wrote in message
> sometimes when I enter decimal fractions Excel thinks this is a date.
> How do
...i need monthly ledger that is catagorized by payment due dates
"j.marie" <email@example.com> wrote in message
PLEASE write your question in the body of the post, not in the subject line.
This is not a chatroom. Thankyou.
In answer to your question, you would be better advised to buy an
inexpensive dedicated accounting package. That will do what you want "out of
...Remove time portion from date on Excel 2007 chart
I am trying to remove the auto generated time of 00:00 to every date
in my chart. I have tried setting the format, but it just ignores
whatever I try to input. Any help would be appreciated.
Where does this appear? Which labels?
Peltier Technical Services, Inc.
> I am trying to remove the auto generated time of 00:00 to every date
> in my chart. I have tried setting the format, but it just ignores
> whatever I try to input. Any help would be appreciated.
...date time problem
I would like to have a date cell that can have an input mask of __/__/__ so
that a user need only enter the numerics of a given date; i.e 052405. I
I tried setting the cell format to custom mm/dd/yy and I get a return date
of 10/1/43 !!!!!???? Why has excel lost the correct date? Regions
global show the correct year range, and Excel is set to 1900 time?
What do I need to do to correct this?
XL's parse engine and display engine are separate - the displayed format
has nothing to do with how the entry is parsed (other than Text entries
are not parsed at all). For a workaro...Calculating tax on rebates
I need to get a quick calulation to help me sovle a problem. I need to
issue a $50.00 credit, but need to take a tax rate into account. I
need to know the calculation if the $50.00 final credit amount is in
A1, and the tax rate is in A2, what calculation would be in cell A3
that would show the pretax price?
This is pretty straightforward algebra:
f = p * (1 + r)
A3: = A1 / (1 + A2)
Sabosis <firstname.lastname@example.org> wrote:
> I need to get a quick calul...