How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Ansh P. Your Own Question

Ansh P.
Ansh P., MS Office Specialist
Category: Microsoft Office
Satisfied Customers: 8148
Experience:  Computer Science Engineer with 10 years experience in MS Office (All Versions).
14055801
Type Your Microsoft Office Question Here...
Ansh P. is online now
A new question is answered every 9 seconds

i WOULD LIKE TO KNOW THE FUNCTION AND/OR FORMULA TO CALCULATE

This answer was rated:

i WOULD LIKE TO KNOW THE FUNCTION AND/OR FORMULA TO CALCULATE THE TIME DURATION BETWEEN 22:30 AND 03:45 OF THE FOLLOWING DAY.

JATechSpecialis :

Hi and Welcome to JustAnswer.com

JATechSpecialis :

Are you using Excel?

Customer:

yes 2007

JATechSpecialis :

The cells will only take time or date+time

JATechSpecialis :

?

Customer:

is it possible for me to calculate the duration when there a date and time change?

JATechSpecialis :

yes

Customer:

How can I do that? I know how if it's in the same foday but don't know how to formulate it for continuation into the followin.g day

JATechSpecialis :

Please wait, I will find this out for you

JATechSpecialis :

ok how is the format of your date

JATechSpecialis :

?

Customer:

not sure your question

Customer:

did not consider date into the formula. so i need to know how to include it

JATechSpecialis :

For example: 18/10/08 13:14






JATechSpecialis :

Is that fine?

Customer:

ok, now how do i display only the time in cells A1 AND B1?

JATechSpecialis :

See if you use date-time or only time, just format the cells as custom - [h]:mm

JATechSpecialis :

once done, you can simply subtract both cells

Customer:

if i formate the cell " time" I can not calculate the duration of hours. so if i formulate using date-time i can custom display the cell [h]:mm which will give me the hours.

JATechSpecialis :

yes correct

JATechSpecialis :

if you use only time and if the time is only one day ahead, it can be calculated

Customer:

ok, thanks. i will try it.

JATechSpecialis :

Sure, let me know if you have further questions or kindly rate me below

Ansh P. and other Microsoft Office Specialists are ready to help you