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
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 >,<
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 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
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
Dear all,
I am having some difficulties on this can someone help me
I have this
Date
Hour
Minute
Second
02-10-2010
3
2
6
and I want in cell E 02-10-2010 03:02:06
This is to make calculations between events
Regards,
cucaracha
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
I have the following formula =INT(IF(D40="",NOW(),D40)-B40)&" dys "&TEXT(IF(D40="",NOW(),D40)-B40,"h"" hr ""m"" mn"""). It returns the time between two dates. But now i have a spread sheet full of times for each month and i need to find the average time spent during each month.
02-Jan-08 02-Jan-08 0 dys 2 hr 16 mn
03-Jan-08 10-Jan-08 6 dys 21 hr 29 mn
07-Jan-08 07-Jan-08 0 dys 14 hr 29 mn
07-Jan-08 07-Jan-08 0 dys 6 hr 33 mn
07-Jan-08 07-Jan-08 0 dys 5 hr 37 mn
08-Jan-08 09-Jan-08 0 dys 18 hr 13 mn
= Average ?????
How would i calculate the average since my orginal formula deals with INT?
Any help would be greatly appreciated
KcNewb
