| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours between dates
Hi Everyone,
I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
hi
i think days360 counts days not hours. if your times are that close, you might be better off just subtracting H2 from G2 and formating the results as time ie [hh]:mm:ss. the brackets around the hh will cause the hours to accumilate and not roll over every 24 hours. Regards FSt1 "Linda RQ" wrote: Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
=B1-A1 and format as [h]:mm
-- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
If you need the actual decimal hours (13.666...), then try this formula...
=24*(H2-G2) -- Rick (MVP - Excel) "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
You Da Man Rick! Thanks!
"Rick Rothstein" wrote in message ... If you need the actual decimal hours (13.666...), then try this formula... =24*(H2-G2) -- Rick (MVP - Excel) "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
Thanks Bob, I tried to put formatting in but I kept getting an error because
I really don't know where to put the parentheses so I tried Rick's solution and it worked! "Bob Phillips" wrote in message ... =B1-A1 and format as [h]:mm -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
Thanks FSt1, I couldn't figure out how to put the formatting into the
formula/fx Linda "FSt1" wrote in message ... hi i think days360 counts days not hours. if your times are that close, you might be better off just subtracting H2 from G2 and formating the results as time ie [hh]:mm:ss. the brackets around the hh will cause the hours to accumilate and not roll over every 24 hours. Regards FSt1 "Linda RQ" wrote: Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
hi
don't put the fomating in the formula. right click the desired cell, choose format cell. click the number tab. click custom. enter the custom format there. once entered, you can format other cells by selecting the custom format Regards FSt1 "Linda RQ" wrote: Thanks FSt1, I couldn't figure out how to put the formatting into the formula/fx Linda "FSt1" wrote in message ... hi i think days360 counts days not hours. if your times are that close, you might be better off just subtracting H2 from G2 and formating the results as time ie [hh]:mm:ss. the brackets around the hh will cause the hours to accumilate and not roll over every 24 hours. Regards FSt1 "Linda RQ" wrote: Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
It is square brackets, not parentheses.
-- __________________________________ HTH Bob "Linda RQ" wrote in message ... Thanks Bob, I tried to put formatting in but I kept getting an error because I really don't know where to put the parentheses so I tried Rick's solution and it worked! "Bob Phillips" wrote in message ... =B1-A1 and format as [h]:mm -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
So it would be =B1-A1[h]:mm
"Bob Phillips" wrote in message ... It is square brackets, not parentheses. -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Thanks Bob, I tried to put formatting in but I kept getting an error because I really don't know where to put the parentheses so I tried Rick's solution and it worked! "Bob Phillips" wrote in message ... =B1-A1 and format as [h]:mm -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
You left out the "and format as" part...
=B1-A1 and format as [h]:mm -- Rick (MVP - Excel) "Linda RQ" wrote in message ... So it would be =B1-A1[h]:mm "Bob Phillips" wrote in message ... It is square brackets, not parentheses. -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Thanks Bob, I tried to put formatting in but I kept getting an error because I really don't know where to put the parentheses so I tried Rick's solution and it worked! "Bob Phillips" wrote in message ... =B1-A1 and format as [h]:mm -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hours between dates
No it would be
=B1-A1 as the formula in the cell, then select menu FormatCellsCustom and enter [h]:mm in the inputbox. -- __________________________________ HTH Bob "Linda RQ" wrote in message ... So it would be =B1-A1[h]:mm "Bob Phillips" wrote in message ... It is square brackets, not parentheses. -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Thanks Bob, I tried to put formatting in but I kept getting an error because I really don't know where to put the parentheses so I tried Rick's solution and it worked! "Bob Phillips" wrote in message ... =B1-A1 and format as [h]:mm -- __________________________________ HTH Bob "Linda RQ" wrote in message ... Hi Everyone, I have been playing around and can't quite get it. I have 2 columns Start Date and Time and End Date and Time I tried this function =DAYS360(G2,H2) 4/5/07 4:12am 4/5/07 5:34 pm Gives me 0.00 for an answer. I need the hours The ultimate goal is to calculate total days which if I have 2 records which give you an answer of 12.00 that would be 1 day. I think once I get this formula fixed I hope I can get the other by selecting all the records and divide by 24 to get my total days? Thanks, Linda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| net no of hours bewtween tow dates | Excel Worksheet Functions | |||
| Determining work hours between dates / hours | Excel Worksheet Functions | |||
| dates to hours | Excel Discussion (Misc queries) | |||
| working with dates and hours | Excel Worksheet Functions | |||
| get total hours from 2 dates | Excel Worksheet Functions | |||
![Linda RQ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
