Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates to hours
I have two times in my spreadsheet.
I have a job that has a start time that begins at 07:00 and ended the job 3-days later at 23:47. The real lapsed time is days from start to finish, however I keep getting a (-) negative, ###### answer. Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours) Thanks, Champ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates to hours
Hi,
A1= Earlier date/time A2= later date/Time A3 formula =A2-A1 Format A3 as [hh]:mm Mike "Champ" wrote: I have two times in my spreadsheet. I have a job that has a start time that begins at 07:00 and ended the job 3-days later at 23:47. The real lapsed time is days from start to finish, however I keep getting a (-) negative, ###### answer. Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours) Thanks, Champ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates to hours
Mike thanks, that does work.
I was trying to keep the format of times only, but doing that never will define the date, just the times. Is there a way for the times to look at another set of cells and then calculate this? If not, what you gave is just fine. ex: IN OUT 6/18/08 22:30 6/20/08 22:30 Cell A1 B1 C1 D1 Just a thought... Thanks again, Champ "Mike H" wrote: Hi, A1= Earlier date/time A2= later date/Time A3 formula =A2-A1 Format A3 as [hh]:mm Mike "Champ" wrote: I have two times in my spreadsheet. I have a job that has a start time that begins at 07:00 and ended the job 3-days later at 23:47. The real lapsed time is days from start to finish, however I keep getting a (-) negative, ###### answer. Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours) Thanks, Champ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WORK HOURS DIFFERENCE BETWEEN TWO DATES | Excel Worksheet Functions | |||
working with dates and hours | Excel Worksheet Functions | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
get total hours from 2 dates | Excel Worksheet Functions | |||
Calculate work hours between two dates | Excel Worksheet Functions |