Convert minutes to hours and minutes
I have a formula that converts whole numbers with a decimal to minutes. Example 1.5 =110 minutes. I am trying to convert the total minutes back to a whole number with a decimal in minutes. For example 110 minutes = 1.5. If I divide the minutes by 60 I get 1.83 where I want to get back to the 1.5. Does anyone know the formula to do this??
maybe I'm missing smething but how did you convert
1.5 to 110 minutes (I had suspected 90 minutes??)
So the value 1.83.. (1,83 hours) is correct for 110 minutes (if
converted to decimals)
Sally IC wrote:
> I have a formula that c...Converting Minutes:Seconds to Minutes
I could download my telephone bill online.
When I view the bill online The Duration of Call column which is listed in
minutes appears as (for example)
5:00 ..............(for 5 minutes)
16:00.............(for 16 minutes)
21:00.............(for 21 minutes)
29:00.............(for 29 minutes)
32:00.............(for 32 minutes)
When I copy or download the bill this column appears as (Same example)
5:00................(for 5 minutes)
16:00.............(for 16 minutes)
29:00:00.............(for 29 minutes)
32:00:00.............(for 32 minutes)
I would like to be able to do a total for the number o...Converting Minutes to Seconds
I have a list of times formated in minutes and hundredths of minutes
for example 7360.50 and 8622.42. I need to be able to covert thes
numbers to seconds. I am sure this is an easy formula, I just don'
have the time to think it through.
PS. Just to clarify 7360.50 is the same as 2:40:30 and 8622.42 i
Message posted from http://www.ExcelForum.com
I think you got it wrong, haw can 7360.50 minutes be only 2:40:30
You need to use [hh]:mm:ss as format to get all hours, otherwise get up to
However if you want it in seconds just multiply with 60
=7360.50*6...Word 2008 keeps crashing after a document is open, a few minutes after typing anything
Operating System: Mac OS X 10.6 (Snow Leopard)
For the last two weeks Word 2008 has been freezing after a open my document and start typing. The documents were created in word. I removed the "Normal.dotm" file as some suggested for similar issue. But it does not solve the problem. I reinstalled office with all updates again and nothing. PLEASE HELP! I'm writing a dissertation! <br><br>Here is the "problem report for word". I'm sorry but is long. <br><br>Date/Time: 2010-05-10 21:20:20 -...Minutes into Hours and Minutes
I have a spreadsheet which I use to keep the times of some events. I get
these numbers in minutes and need to convert them into HH:MM format.
Just divide your minutes value by 86400 (the number of minutes in a day)...
and format the cell like this... [hh]:mm (the square brackets allow the
hours to be more than 24).
Rick (MVP - Excel)
"david d" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet which I use to keep the times of some events. I get
> these numbers in m...getting Outlook "popup" window every few minutes.....
When using Outlook 2002 I get a box popping up on my screen
every few minutes saying:
"Unable to update public free/busy data. Operation failed"
I recently set up a second data file and successfully
created a rule to divert emails from a domain name I have
to that data file and loaded a bunch of appointments into
the calendar of that data file. Is this popup to do with that?
Try starting Outlook once with the /CleanFreeBusy switch. If you need help
using Outlook command line switches, look here:
J...To convert minute into hour and minute
How to convert 250 minutes into 4 hours and 10 minutes? Which the formula
The result of one determined function is 250. I would like from this value to convert it into 4 hours and 10 minutes (4:10). How I make
The formula counts the numbers of times, during one week, that it has lessons of Mathematics. The result is 5 lessons, being that 1 lesson of mathematics corresponds the 50 minutes. Then I multiply 5*50=250. What I want is that value 250 either converted into 4h and 10min or 4:10 hours
Enter the 50 minutes as 00:50, multiply by 5 = 4:10
To get the time as decimal 00:50*5*24 = ...Minutes to hrs calcultion
I have a form where you enter minutes but the calculation needs to give the
result in Hr:min. I've tried
The result being 3.3 but I need it to show 3hrs 20 min
Sounds daft I know!
You could try the following:
=INT(A2/60)&" Hrs "& (MOD(A2,60))&" mins"
this will look at A2 - if it has 200 the formula will translate that to
3 Hrs 20 mins
Mark Lewis wrote:
>I have a form where you enter minutes but the calculation needs to give the
>result in Hr:min. I've tried
> A2=180 A3=20=SUM(A2,A3)/60
...Outlook 2007 take ten minutes to open
My Outlook started to take ten minutes to open after boot. Tried all
published fixes? Was working fine last week,
Try opening Outlook using the safe switch, ok then?
"Damaker" <email@example.com> wrote in message
> My Outlook started to take ten minutes to open after boot. Tried all
> published fixes? Was working fine last week,
...Converting Hours and Minutes to Just Minutes
Does anyone have a formula for converting for example 1 hr 20 m to 8
minutes? Thanks for your help. Karen
cny2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=49840
The answer depends on the format of your data, and perhaps how the data
is stored. For instance, is it in the format of your example, 1 hr 20
m, contained as text in a single cell? If yes then you'll need to
parse the 1 and the 20 out s...Summing Hours and Minutes
I have a TIME ...I then subtract from it another TIME.
The first is formatted like 4:30 PM the second is formatted
like 10/5 5:00 PM. I then get the answer and I format it
using hh:mm so my answer may be 5:44 ...meaning
5 hours 44 minutes....
I try to take all the answers and get a sum and I get #####
I make the column wider...but its never wide enough so I suppose something
is wrong with my premise here.
Any help is greatly appreciated.
Try the following formula in another cell,
"&IF(LEN(ROUND(MOD(B10*24,1)*60,2))=1,"0"&RO...Send 900 Billion valid Emails in Just 5 Minutes Only!
...convert hours and minutes to minutes
I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into total
minutes... Any ideas
Use a formula like the following:
Format the cell as General or Number.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"idaho" <firstname.lastname@example.org> wrote in message
>I need to convert hours and minutes 1:45 (One Hour and 45
>Minutes) into total
> minutes... Any ideas
If it's just formatting you want. Try this Custom Form...Outlook won't open (takes 5 minutes)
I have a user here at work running XP that says sometimes
when she tries to open Outlook, nothing comes up. She will
try a couple of times and a few minutes later Outlook will
open several windows. (1 for everytime she tried to open
it) At other times it just opens right up the first time
correctly. I looked at the task manager and the times it
does not seem to come up, it will have a Outlook.exe file
running. I ran the repair and fix and it still does it.
I wanted to add my email address in case anybody had any
ideas what to do.
I have this problem on seveal Win ...How to add hours and minutes?
I want to calculate the following
start time finish time meal break total worked
Formula would be something like
finish time - start time - meal break = total
That part I can do
And then add the total time worked so that I would get total hours and
minutes worked over a two week period.
The end result would be something on the order of 48:20 where the 48 is
the hours and the 20 is the minutes.
Can anyone help?
Calculating with time is well explained here:
Microsoft MVP - Excel
...Excel is starting over a minute
Sorry if this subject was covered already, but I really need help, and
cannot find the answer.
I am using Excel 2003
Clean start (with blank sheet) take over a minute, it is behaving like it
hanging, no response.
The same is with opening a XLS file eg. from e-mail or dblclicking on an XLS
I am not using any anti-viral software.
I checked, it is not processing any files in that time.
I don't have anything in XLSTART folder.
Those are potential reasons I found on the net and I checked them.
I would appreciate any ideas.
...rolling up minutes to hours
setting up a meeting where tasks run 10-30 mins each. How do you make Project
add that time up to the overall time in that section? (ex. 3 20-min tasks = 1
we don't want percentages or decimals of the day, just hours
I'm not sure I understand completely what your question is. If you have
the meeting set as a summary task and each of the tasks making up that
meeting indented as subtasks under the meeting summary task, the summary
task duration should show the total duration of the span of the tasks.
Have you linked each of the subtas...MSExchangeIS 1021 error repeating every minute
I get about 5 of these errors popping up every minute on my Exchange server.
When I open it, they all say:
DOMAIN/user was unable to connect as /o=Domain/ou=SAF Administrative
Group/cn=Recipients/cn=epage. Error 0x3f2.
I have been through the following articles already and no luck:
http://support.microsoft.com/default.aspx?scid=kb;en-us;83464...How do you subtract time? (ie 03:15 am minus 5 minutes)
I am setting up a spreadsheet to figure on start time from the end time to
start time. I need to subtract time from the previous cell to the next cell.
Use the article 214094 from support.microsoft.com
Also make sure that you have the cell formatting to Time 37:30:55
> I am setting up a spreadsheet to figure on start time from the end time to
> start time. I need to subtract time from the previous cell to the next cell.
XL stores times as fractional days, so all you need to do is subtract,
and format the resulting cell as a time:
...Every 2 minutes
Hi, if I have a table:
'17/11/2009 23:50:35' 10
'17/11/2009 23:51:30' 20
'17/11/2009 23:51:35' 21
'17/11/2009 23:52:10' 1
I need to do a group by showing the sum at every 2 minutes, so it'd be:
The column returned must show: Minute = 52 - Sum: 10+20+21=51
Minute = 54 - Sum: 1
Using MS SQL 2k
> I need to do a group by showing the sum at every 2 minutes, so it'd be:
> The ...Convert hours:minutes to minutes
I have a calculated field in a query that returns the difference between two
times with a time format of h:nn; for example, one hour and thirty minutes is
displayed as 1:30. I need the value of 1:30 displayed in minutes, so I need
to see the value as 90 minutes. If I use the "n" format for minutes it only
returns the minutes without the hours so in the case of 1:30 it only returns
30 and not 90. How do I format or calculate the field to return the value in
minutes so that 1:30=90, 2:45=165, 0:33=33?
"Scott" <Scott@discussions.microsoft.com> wrote in message...Display subject lines that carry [error:] on a web page, which refreshes every x minutes automatically #2
I don't know if this is possible or not. But it is worth giving a
I have an application that sends notification emails saying that
is an error that has occured with the application and this email
contains "error:" as a constant term in the subject line, and they
all from h...@application.com.
Now, What I want to do is my outlook macro or code should
refresh the outlook inbox look for subject line that has "error" and
verify it is from h...@application.com and display this error subject
line on a web page. This should happen every ...Formula for minutes to days:hours:minutes
I have a report out of another system that shows ventilator time in minutes
and the end user would like to see it in days:hours:minutes. It's difficult
to put your head around how long 7171 minutes is.
Divide by 1440 and use a custom format [h]:mm
will get you the time in hours
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"QueenCutieT" <QueenCutieT@discussions.microsoft.com> wrote in message
>I have a report out of...Converting Hours an minutes just into minutes
Is thier a formula to use to change hous and minutes, just into minutes ex:
01:30 (1 hour and 30 minutes) into 90 minutes. And how do you format the
Excel stores times as fractions of a day.
Therefore to convert to hours, multiply by 24 (result 1.5)
To convert to minutes multiply by 1440 (24 * 60 ) (result 90)
Format cell as General.
"Six Sigma Blackbelt" <SixSigmaBlackbelt@discussions.microsoft.com>
wrote in message
> Is thier a formula to use to change hous a...hours and minutes storing past midnight
i have a query that sums up all hours and stores this as a main figure lets
for this question say
to store this in an access table i need to use a text type
but when i try and do 78:34-30:00 to give me 48:34 it gives me a message
saying invalid data type, now im guessin its due to it being saved as a
string but am an unable to find the correct data type in a table to store it
On Fri, 7 Dec 2007 11:19:00 -0800, Rivers <Rivers@discussions.microsoft.com>
>i have a query that sums up all hours and stores this as a main figure lets
>for this question say