I running some tests that require me to do a couple of checks at certain points.
Is there a formula I can use that will automatically add 90 minutes to a time that I enter into a cell? For instance, I enter 13:24 into a cell...how do I get another cell to display 14:54?
Thanks!
With a time in A1, use:
=TIME(HOUR(A1),MINUTE(A1)+90,SECOND(A1))
Gary's Student
If 13:24 is in A1 and you want 14:54 in B1, then
=A1 + (1.5/24)
Time is maintained in Excel as a fraction.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
....also
=A1+"0:90"
format result cell to show a time value
What is the start time is 23:30 (is that possible) - what should the result be?
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks