Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert times from hours to minutes?
I am trying to do a spread sheet where I have a starting time of 10:00am and
an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
#2
|
|||
|
|||
Kim
It is incrementing minutes greater than 60 to hours but not showing them. Go to FormatCells...NumberCustom and enter [mm]:ss the [ ] stop it incrementing. the same with hours to days [h] or [hh] -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "kkrebs" wrote in message ... I am trying to do a spread sheet where I have a starting time of 10:00am and an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
#3
|
|||
|
|||
Hi
try =A2-A1 if these are your times. For the final result use a custom format such as [mm]:ss -- Regards Frank Kabel Frankfurt, Germany "kkrebs" schrieb im Newsbeitrag ... I am trying to do a spread sheet where I have a starting time of 10:00am and an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
#4
|
|||
|
|||
Thanx, but when I try either of these my answer comes out to 1290:00. What
am I doing wrong? "Frank Kabel" wrote: Hi try =A2-A1 if these are your times. For the final result use a custom format such as [mm]:ss -- Regards Frank Kabel Frankfurt, Germany "kkrebs" schrieb im Newsbeitrag ... I am trying to do a spread sheet where I have a starting time of 10:00am and an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
#5
|
|||
|
|||
Hi
so tell us please: - what formula have you tried exactly - what values are in the referenced cells - what is your expected result -- Regards Frank Kabel Frankfurt, Germany kkrebs wrote: Thanx, but when I try either of these my answer comes out to 1290:00. What am I doing wrong? "Frank Kabel" wrote: Hi try =A2-A1 if these are your times. For the final result use a custom format such as [mm]:ss -- Regards Frank Kabel Frankfurt, Germany "kkrebs" schrieb im Newsbeitrag ... I am trying to do a spread sheet where I have a starting time of 10:00am and an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
#6
|
|||
|
|||
I'm sorry. My blond roots were showing again. I had the wrong formula.
Thank you for all your help. "Frank Kabel" wrote: Hi so tell us please: - what formula have you tried exactly - what values are in the referenced cells - what is your expected result -- Regards Frank Kabel Frankfurt, Germany kkrebs wrote: Thanx, but when I try either of these my answer comes out to 1290:00. What am I doing wrong? "Frank Kabel" wrote: Hi try =A2-A1 if these are your times. For the final result use a custom format such as [mm]:ss -- Regards Frank Kabel Frankfurt, Germany "kkrebs" schrieb im Newsbeitrag ... I am trying to do a spread sheet where I have a starting time of 10:00am and an ending time of 11:30am and I want the sum to be total minutes not hours and minutes. It comes out at 30:00 and I can't figure out how to have it add in the other hour. Can any one help? Thank you! Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) |