Thread: Current Time subtract a specific amount every second
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Current Time subtract a specific amount every second
Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred

"Jman" wrote in message
...
I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on the
Current Time in D4
D4 contains =now()


Reply With QuoteReply With Quote