I have a spreadsheet in which I formatted total hour columns as h:mm although it shows in the formula bar with a date attached to the hours & minutes (eg 8/25/1900 4:32:00 AM). The total hour calculations work, however when trying to pull the data from these cells into another work sheet and do calculations it moves the date along with it, is there some way to remove the date and keep the same format?
I have tried using it with the number format using two decimal places, however the totals do not work out correctly, the conversions are not the same.
I am creating a Little League Schedule and want to start Saturday games and have the lower cells ad 2hr 45min to whatever time I post in the upper cell
Hi,
I am trying to set myself up a timesheet using Office 2007 (OS - Vista Home Premium 32 bit)
I enter my start time and finish time and ask for the time difference - I then have a hidden column which converts the time difference to a general number so I can use it to multiply with my hourly rate. My problem is that the hidden column does not return the converted minutes, just the hours so therefore when I multiply it with my hourly rate is not correct as it misses the minutes.
This is how it looks in row 3
In A3 I enter the date e.g. 10/03/08
In B3 I enter my start time e.g. 09:30
In C3 I enter my finish time e.g. 17:00
In D3 I have =IF(A3="","",C3-B3) which returns 08:30
In E3 I have =IF(D3="","",HOUR(D3)) which returns 8 (this is a hidden column)
This is where the problem lies as I need it to convert 08:30 to 8.5 so i can multiply it with my hourly rate.
In F3 I have =IF(E3="","",IF(E3>=7,$F$1,IF(E3=4,$F$1/2,$F$1/7.5*E3))) which returns what I should charge but if I work anything with a 1/2 hour in it the results do not calculate it.
I'm sure this is something very simple and would appreciate any help with which function I should use in E3 to return the 8.5 needed.
Many Thanks
Zobble!
Hello,
I want to add a 6 Days, 2 hours and 31 minutes to the current date and time and show the result in date/time format.
I tried using Now() in cell A1, and then formatting cell B1 as D:HH:MM and then typing 6:2:31 into that cell, and the adding cells A1+B1, but can't get this to work.
Do you have any suggestions for a formula that would work for this?
Thanks for any help!
Gordon
Here is a traditional Indian time calculation
(1 day) 24 Hr = 60 N
1 N = 60 V = 24 Minutes
How to formulate this in excel 2003.
If A1= HH (hour), B1=mm (minutes) - Inputs
A2 should show NN : B2 should show VV - Result
And Viceversa.
If A1= NN (hour), B1=VV (minutes) - Inputs
A2 should show hh : B2 should show mm - Result
------------
hh - hours, mm - minutes, NN - Nazhigai, VV - Vinadi - all are numbers
I am needing to produce a weekly report that shows how many total hours have been worked by my department but the issue is the format that is on the spreadsheet supplied.
It gives me each agents work times for the week as:
Days:Hours:Minutes:Seconds (i.e. 1:18:45:23)
I can not seem to find a formula that will let me sum this formatted time and manually adding it is very labor intensive. Is there any code that would convert the format shown above to:
Hours:Minutes:Seconds (i.e. 42:45:23)
Any assistance with this would be greatly appreciated!
Thank you,
Eric
dear Mr/Ms
I need some formoula to cunvert hour to minute in worke sheet in excel .
PLS Offer me ASAP.
With thank
Habib
i've got problem on how to formula the following:
i have 2 tables, 1 is the for report and the other is for computation only
table 1 looks like this
http://img842.imageshack.us/i/table1l.jpg/
and the table 2 looks like this
http://img163.imageshack.us/i/table2.jpg/
now on table 2 i would enter the time in and time out and on the yellow cell supposed to be the total number of hours.
now for example the total number of hours is 2:45 (2 hours and 45 minutes)
now on table 1 there's hour and minutes column
i dont know how to put the number of hours(on hours column) and number of minutes(on minutes column) on table 1 using a formula
hope that you can help me >,<
I have a stacked bar graph that I'm using to plot tasks but currently it's using days as its minimum time, the problem is a lot of the tasks are done in a day and thus don't show anything on the chart. Is there any way to make its accuracy to the hour or half hour?
Does anyone know how to format a cell, or what formula to use, so that when an entry is made the colon is automatically put in? so that 1011 shows as 10:11
Thanks
