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?
...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...Timeline Graph
Hello, I am trying to make a timeline in excel but it's giving me some
trouble. I concluded the best graph type to use was floating bars as they
have a start position and a lengh. This is fine for dates of say: -100
to -50 and 100 to 150 but excel can't seem to handle going over the origin
point, it won't draw -100 to 100. I'm just trying to do a basic rise and
fall of different civilisations, can anyone help? Thanks.
You could increase all the values by the lowest negative number, and
create a chart from the adjusted numbers. For example, if -100 is the
earliest year, inc...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
...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.
...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!
...Bar Graphs #5
I have set-up a bar-graph consisting of four horizontal bars. I would like
to overlay one particular bar onto another specific bar - leaving the other
two as is. Is this possible? I have looked at the 'Overlap' option but
unfortunately while this is on the right theme, it overlaps everything!
Any help greatly appreciated!
On Tue, 12 Jun 2007, in microsoft.public.excel.charting,
Don <Don@discussions.microsoft.com> said:
>I have set-up a bar-graph consisting of four horizontal bars. I would like
>to overlay one particular bar onto another specific bar - leaving ...x/y axis graph
i need to do an x/y axis graph, but my y axis must be alphabetical not
numerical , how do i do that.
...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.
...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...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...help with line graph
i accidently and unknowingly tuned off the line on my line
graph, when i try to do the line graph the line isn't
there. please help!!!!!!!!!
Can you see the markers on the chart? If so right click one, select Format
Data Series; on the Pattern tab put check mark next to Line
If you cannot see it; click on chart, tap up/down arrows watching Name box,
when Series 1 show up, use menu item Format.
remove CAPS in e-mail address
"darci" <firstname.lastname@example.org> wrote in message
news:149a201c3f8f9$4cf70c70$a601280a@...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." <email@example.com> 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...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" <firstname.lastname@example.org> 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...Date format 03-03-08
How do I get a date to print as mm-dd-yy in a field?
On Sun, 02 Mar 2008 23:43:02 -0500, BC wrote:
> How do I get a date to print as mm-dd-yy in a field?
Set the format property of the Date control to:
Please respond only to this newsgroup.
I do not reply to personal e-mail
...Appending or Up-dating a formula
I am using an =Ave function in a formula to average quite a few cell values
together. I add new information all the time; sometimes 5 or 6 new cells at
How can I append or up-date my formula to include these new cells with out
have to type the new cells into the formula?
When I make the cell that has the formula in it active/edit, all of the
cells that are referenced in the formula have a highlight around them.
Is there a key or key combination I can press while clicking on the cells I
want to add to the formula?
see your post in Excel.misc
Frank ...date format into day of week
I have column in excel which show date in format 2009-08-21. Is it possible
in new column to get day of week from this data?
Is this what you are looking for?
Rick (MVP - Excel)
"Steve" <Steve@ggmmaaiill.com> wrote in message
>I have column in excel which show date in format 2009-08-21. Is it possible
>in new column to get day of week from this data?
Is this what you are looking for?
Rick (MVP - Excel)
"Steve" <Steve@ggmmaaiill.com> wrote in me...