get time and date difference based on the hour or minutes given

hi there,

any body knows how to get the date and time difference if the given data say is:

given current time is:10-05-2013 10:38 AM

then user enters like: 10 ( means 10 hours)

the difference would be: 10-05-2013 12:39 AM (this is easy to get , however if the user enters in minutes like 45 which is in minutes then i don't get the accurate time and date)

can any one help on this? thanks in advance

can you submit a sample spreadsheet with existing formulas?

hi there!

here are the formulas:

given current time:

Please Login or Register  to view this content.

(this is placed in C3)

to get the difference:

Please Login or Register  to view this content.

(this is placed in C7)

user enters on C5 (like 10, which means 10 hours)

If the user enter 45 minutes, you want the hours to decrease? Is that what you want?

Originally Posted by danjim02

If the user enter 45 minutes, you want the hours to decrease? Is that what you want?

yes, basically if the user enters like 10 (which means 10 hours) then this should be subtracted from the current date and time...however if the user enters like 45 minutes...this comes the challenge i am having...i know i sound confusing but can you give me an idea how can this be done? like how can I get the date and time difference if the user enters hours or minutes