LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Weekday + Time Calculation in Cell

Dear all,

If A1 is equal to Mon 1300, and when I plus another 12hrs in A2, it will
become Tue 0100 in A2.

Any idea how to achieve this?

Thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic time conversion in the SAME cell megs Excel Discussion (Misc queries) 8 November 19th 06 06:19 PM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
multiplycation of money cell and time cell engr625 Excel Worksheet Functions 1 August 3rd 05 04:53 AM
time calculation with military time Ron Thetford Excel Worksheet Functions 8 July 29th 05 07:24 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"