Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
I have a co-worker that is trying to create a spreadsheet to keep track of
how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
Try
=(B1-A1)*24 Where A1 is start (earlier time) and B1 is end Format as general Mike "tpayne" wrote: I have a co-worker that is trying to create a spreadsheet to keep track of how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
sorry for minutes use
=(B1-A1)*24*60 Mike "tpayne" wrote: I have a co-worker that is trying to create a spreadsheet to keep track of how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
Thanks Mike, that will work perfectly. I appreciate your help.
"Mike H" wrote: sorry for minutes use =(B1-A1)*24*60 Mike "tpayne" wrote: I have a co-worker that is trying to create a spreadsheet to keep track of how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
=(B1-A1)*24*60
Note that the time should be entered as "2:00 pm", not "2:00p.m.". 14:00 is O.K. -- David Biddulph "tpayne" wrote in message ... I have a co-worker that is trying to create a spreadsheet to keep track of how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time can it be done with a fx?
You can put =B2-B1 in a cell to compute the difference, then use formatting
to display it however you want. [m] will show just minutes even if it goes over an hour, while h:mm will show hours and minutes, or use [h]:mm to show hours even if it goes over one day. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tpayne" wrote in message ... I have a co-worker that is trying to create a spreadsheet to keep track of how many minutes it takes to complete drafting projects. He wants to be able to enter his start time in one cell, his finish time in another cell and be able to get a result of how much time it took in minutes or hours in another cell. For example, he starts and enters in a cell 2:00p.m. then in the next cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if he uses military time he wants the same results. Is there a function that will calculate time like this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtracting time | Excel Worksheet Functions | |||
Subtracting time | Excel Worksheet Functions | |||
Subtracting Time | Excel Worksheet Functions | |||
Subtracting Time from NOW() Value | Excel Worksheet Functions | |||
Subtracting time | Excel Worksheet Functions |