Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diference between two hours in Minutes
I need to fin how many minutes are between two hours...for example:
10:30am to 1:30pm I have tried to subtract both times and then custom format the cell [mm] which will work......but I am trying to make another calculation with that result and it gives me a number that really is not what I expect......it should be a simple subtraction 180 minus whatever number. is there an easier way to get the total minutes between to times without having to custom format the cell?.....thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diference between two hours in Minutes
Try it this way:
=(B1-A1)*24*60 and then format the cell as General or as Number. This assumes that B1 is the later time than A1. Hope this helps. Pete On Jul 2, 9:32*pm, jcheko wrote: I need to fin how many minutes are between two hours...for example: 10:30am to 1:30pm I have tried to subtract both times and then custom format the cell [mm] which will work......but I am trying to make another calculation with that result and it gives me a number that really is not what I expect......it should be a simple subtraction 180 minus whatever number. is there an easier way to get the total minutes between to times without having to custom format the cell?.....thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diference between two hours in Minutes
it worked thanks....
"Pete_UK" wrote: Try it this way: =(B1-A1)*24*60 and then format the cell as General or as Number. This assumes that B1 is the later time than A1. Hope this helps. Pete On Jul 2, 9:32 pm, jcheko wrote: I need to fin how many minutes are between two hours...for example: 10:30am to 1:30pm I have tried to subtract both times and then custom format the cell [mm] which will work......but I am trying to make another calculation with that result and it gives me a number that really is not what I expect......it should be a simple subtraction 180 minus whatever number. is there an easier way to get the total minutes between to times without having to custom format the cell?.....thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Diference between two hours in Minutes
You're welcome - thanks for feeding back.
Pete On Jul 2, 10:17*pm, jcheko wrote: it worked thanks.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |